Comparing the three main ways to get Dynamics 365 data into Power BI

There are a few different ways to get your Dynamics 365 data into Power BI. Now that the Common Data Service connector has come out of preview and is generally available, I figured it would be a good time to have a look at the different methods and how they stack up. The different direct … Continue reading Comparing the three main ways to get Dynamics 365 data into Power BI

Power Query (M) Builder for the XrmToolBox (April 2019 update and fixes)

It has been a little while since the last update, but Mohamed Rasheed and I just added some bug fixes and improvements to the Power Query (M) Builder for the XrmToolBox. If you are new to the Power Query (M) Builder and how it can accelerate Power BI report development from Dynamics 365, check out … Continue reading Power Query (M) Builder for the XrmToolBox (April 2019 update and fixes)

Embed filtered Power BI reports on Dynamics 365 forms – again – the official way

I realize this is my fourth blog on this particular topic, and I am sure it won’t be the last. The occasion: Microsoft has released a new built-in, easier way of embedding Power BI reports on Dynamics 365 and filter them according to record context. The approach is not as user friendly as I had … Continue reading Embed filtered Power BI reports on Dynamics 365 forms – again – the official way

Embed Power BI Visuals in Dynamics 365 – with Secure Embed

Power BI recently started supported embedding Power BI visuals securely out-of-the-box. That means we can now show Power BI reports inside Dynamics 365, without having to deal with authentication. And with minimal use of code, we can filter the visual to the record that it is being displayed on. Like this. I have previously written … Continue reading Embed Power BI Visuals in Dynamics 365 – with Secure Embed

Quickly get Dynamics 365 data in to Power BI for Q&A

The Q&A feature in Power BI is great as it let's users ask natural questions about your data and it will generate visuals and lists to answer those questions. Of course, there's an assumption that Power BI has a data model that uses the same terminology as the user asking, and that the required data … Continue reading Quickly get Dynamics 365 data in to Power BI for Q&A

Use Color Codes from Option Sets in both Dynamics 365 charts and Power BI

Option Sets in Dynamics 365 has a setting for each value to specify a color code. This color code is used in the new Unified Interface in the entity specific dashboards. This is a welcome addition as it makes it more easy to persist colors to a specific value and have it be consistent throughout … Continue reading Use Color Codes from Option Sets in both Dynamics 365 charts and Power BI

Power Query Builder update for XrmToolBox. Create links to Dynamics 365, and handle tables with no records retrieved

We have added some updates to the Power Query (M) Builder for the XrmToolBox. Video is at the bottom of this post. There are 3 main new features: Automatically generate links back to the Dynamics 365 record Generate an empty table when no records are retrieved Use all-attributes in the FetchXML Automatically generate link to … Continue reading Power Query Builder update for XrmToolBox. Create links to Dynamics 365, and handle tables with no records retrieved