Small and medium business | Business Central, N...

Finance Power BI app

(2) Share

Report

Posted on by Sub Mint

172

With the standard list of power bi app reports available for BC, available through the app, is there a way to access the data model in powerbi desktop that makes up these queries?

It would be handy to use the data model as a basis to create further queries that could be created in the power bi service.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

YUN ZHU 102,540 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi, hope the following helps.

Business Central 2025 wave 2 (BC27): Access open-sourced Power BI apps

https://yzhums.com/68178/

Business Central 2026 release wave 1 (BC28.2): Power BI Report Deployments (Centralized Management of Power BI Apps)

https://yzhums.com/72067/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 18,449 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

Hello,

Yes. For the newer standard Business Central Power BI apps, Microsoft provides the .pbix source files, including the semantic model, Power Query queries, relationships, and measures. You first install the app from Marketplace, then download the source code from the installed app and open it in Power BI Desktop; availability starts from version 26.2 or 27.0 depending on the functional app. Alternatively, you can connect Power BI Desktop directly to the published semantic model in the Power BI service and build additional reports on top of it, provided you have the required Build permission.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No
Suggested answer

Grigorios Mavrogeorgis 2,841 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

the source pbix is actually available now — I was going off older docs before. For Finance, Inventory, Inventory Valuation, Manufacturing, Subscription Billing and Sustainability it's there from 26.2, and Sales, Purchasing and Projects from 27.0. The way to get it is a bit hidden. You install the app from Marketplace first, then download the source code from the installed app itself, not the usual Download this file in the workspace. Once you have the pbix you open the full model in Desktop and build whatever you want on top.

If you don't need the whole pbix, you can still do Get data > Power BI semantic models and connect live to the installed model. That's read-only on the model, but you don't have to rebuild — use Make changes to this model to turn it into a composite, then add your own tables, measures and relationships locally. It won't expose the app's Power Query queries, but for extending it's usually enough. You need Build permission either way.
These apps are online only, so no on-prem worry here.

Glad to help - follow up if anything is unclear.
► If this solved it, marking it verified helps others too.
Regards,
Grigorios Mavrogeorgis
Business Central Consultant & AL Developer
Work: Gmsoft Limited
Blog: insidebusinesscentral
LinkedIn: linkedin.com/in/gregorymavrogeorgis

Was this reply helpful? Yes No

Join the conversation

Community site session details

Finance Power BI app

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the June Top 10 Community Leaders

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Finance Power BI app

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the June Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates