Do you want to learn how to create Power BI reports consuming the standard out-of-the-box API’s in Business Central?

Ever wanted to know what you can use the BC API’s for in Power BI without the need for any AL development?

Then have a look here:


In this demo, you will see how easy it is to consume data from different tables in BC, import them into Power BI using the standard, out-of-the-box API’s.


We will create star/snowflake data models and use a little DAX to create powerful measures. And last but not least we will then visualize that data using standard and custom visuals.


Presented by: Steven Renders

View presentation materials here.


Dynamics User Group (DUG) empowers everyday users, administrators, developers, and partners with the tools and information required to excel in their professions. Online discussion forums, video content, training programs, local user groups via Meet-Up, live interactive virtual and in-person events are just some of the resources members enjoy with their free membership.

Visit all the DUG Programs:




5 Thoughts on “Create Stunning Power BI Reports Using the Standard BC API’s

  1. Martin G on December 14, 2022 at 14:59 said:

    Thank you for the insightful video Steven. I have a question: the standard API’s seem to be pages without any filtering applied. Tables such as general ledger entries have millions of rows and take a very long time to load (especially at a rate of 1MB/s). In such cases, is it better to:

    Discard the Business Central connector in Power BI and use Web as a source and create custom API calls with filtering parameters provided in the URL
    Set up custom API Query’s in ML and load those using the Business Central connector.
    Or perhaps even a way to use API filtering on pages using the BC connector in PBI in a way I do not know about yet?

    Happy to hear your thoughts.


  2. Hi, do you know how to get real-time dashboards from Business Central Cloud?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Post Navigation