Power BI offers excellent benefits when connected with Microsoft Dynamics 365 Business Central. It can extract valuable insights from your data in a user-friendly way for making better, data-driven decisions.
Tag Archives: Power BI
Creating Power BI Reports for Displaying List Data in Dynamics 365 Business Central (Filter the Power BI report based on the selected record)
Dynamics 365 Business Central includes a Power BI FactBox control element on many key list pages. The purpose of this FactBox is to display Power BI reports that are related to records in the lists, providing extra insight into the data. The idea is that as you move between rows in the list, the report updates for the selected entry.
Dynamic Commentary in Power BI
Today is another in my series where I am building out my COVID report for Australia. There are a few things I cover in the video today. The main “new” concept is the dynamic commentary, but I also show you some more warts and all insider view of building a report.
Build a Power BI P&L in 5 Mins with InfoRiver
I have been building P&Ls in Power BI for about 6 years, and it’s pretty hard to do. When I was asked to build a video showing how this can be done in just 5 minutes, I was a bit sceptical at first. But as you will see in the video below, it definitely can be done.
Generating Excel Reports Using Power BI, Cube Formulas, Office Scripts And Power Automate
Now that Excel reports connected to Power BI datasets work in Excel Online it opens up a lot of new possibilities for doing cool things with Office Scripts and Power Automate. Here’s a simple example showing how all these technologies can be put together to automatically generate batches of Excel reports from a template.
Analyzing Dynamics 365 Business Central telemetry with Power BI
Telemetry is a concept extremely important with Dynamics 365 Business Central, especially in the cloud world. Every partner should have an internal policy in place for connecting customer’s tenants to Application Insights service and then monitoring the status of these tenants and their performances by periodically checking the telemetry data injected into the Application Insights service.
Implementing Data (As Well As Metadata) Translations In Power BI
Power BI Premium has supported metadata translations – translations for table, column and measure names etc – for a while now. Kasper has a great blog showing how to use this feature here; Tabular Editor makes it very easy to edit metadata translations too. However (unlike SSAS Multidimensional) Power BI doesn’t have native support for data translations, that’s to say translating the data inside your tables and not just the names of objects.