BC data in Power BI

(1) Share

Report

Posted on by Dr Gomathi MVP, MCT...

395 Moderator

Presently to build visualised Power BI report out of BC data we get the details through API’s. (API’s will be written by BC team)

Current Process as best Practice – API’s---à DW--à Power BI or API’s directly to BI and modelling will happen in BI.

I would like to know the other ways and means to visualise Power BI Reports from BC. All other available modes and their reliability will really help us to way forward in the Reporting.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Gerardo Rentería Ga... 25,709 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi

The flow is the one mentioned in the official documentation.

https://learn.microsoft.com/en-us/dynamics365/business-central/across-how-use-financials-data-source-powerbi

BR

Gerardo

Was this reply helpful? Yes No
Verified answer

YUN ZHU 99,364 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Another data that can be accessed is OData in Web Service.

Although the performance is not as good as the API page, this is still a convenient method. Users only need to publish the page to Web Service, and then it can be accessed in Power BI. The fields are the same as on the page.

For example,

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,686 Moderator on at

Like (0)

Report
Copy link

Link copied!

Best is to use APIs. Out of the box APIs or custom APIs, based on queries.

I recommend not to use web services anymore, they will become obselete in the future.

Creating a Datawarehouse is an option, but maybe first give dataflows a try?

Here are some great trainings:

Business Central Power BI Training - Business Central Booster

Microsoft Business Central Advanced Power BI training (businesscentralbooster.com)

Was this reply helpful? Yes No