9

Connecting Power BI for Business Central Data

In this chapter, you’ll use the skills you learned in Chapter 2 on connecting to Business Central and out-of-the-box APIs to connect data to Power BI. In addition, we will walk through connecting Power BI to an Excel file. Finally, we will review setting up parameters in the report to connect to different databases and companies, along with basic best practices in data modeling. In this chapter, we will use Power BI Desktop and publish it to a workspace and Business Central.

Lastly, we will review different visuals and give hints on which visuals to use for what story you are trying to tell. It is essential to have clean data and excellent data modeling skills, and you will want your report to ...

Get Extending Microsoft Business Central with Power Platform now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.