Implementing Microsoft Dynamics 365 Business Central On-Premise - Fourth Edition
by Alex Chow, Roberto Stefanetti
Power BI reporting integration
With the introduction of Microsoft Office 365, Microsoft included something called Power BI (short for Power Business Intelligence). What used to cost a lot of money for a BI solution, Microsoft is now essentially including as part of the Office 365 package. This means that you can utilize Power BI to have a graphical dashboard for your business using live data from Microsoft Dynamics NAV.
The best way to send data to Power BI is to utilize a new object type called Query. The Query object type was actually introduced in Microsoft Dynamics NAV 2013. So, as long as you can publish the query as a web service, Power BI utilized with Excel will suck the data up!
Technically speaking, you do not need Microsoft Dynamics ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access