Power BI – Pardaan.com

How To Integrate Business Central With Power BI

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. Source : Business Central Geek Read more...

2 March 2023

Dynamics NAV & BC Tips & tricks

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…

12 December 2022

Data & Analysis

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…

6 January 2022

Data & Analysis

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…

30 December 2021

Data & Analysis

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…

29 July 2021

Data & Analysis Dynamics NAV & BC Tips & tricks

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…

3 March 2021

Data & Analysis

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…

3 March 2021