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 …

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 …

Power Query Builder updated – now supports FetchXML to get your Dynamics 365 Views into Power BI

The latest version of the Power Query (M) Builder for the XrmToolBox has been updated and it now supports FetchXML. Used for creating data models for Dynamics 365 in Power BI, the Power Query (M) Builder accelerates the development of the Power Query (M) code, that retrieves the records, change column names and their data …

Duplicate Detection Rules Chart in Dynamics 365

I always thought that the duplicate detection rules in Dynamics 365 were a bit of a nuisance. Not because of the rules themselves, but because they are difficult to keep an eye on. The rules will unpublish automatically if you make any configurations to the entity the rule is for. That's fine as long as …

Use the FetchXML Builder to help create charts in Dynamics 365

When creating charts for Dynamics 365, the Advanced Chart Editor in the XrmToolBox can handle most of the presentation and formatting of the chart. The work with the data happens in the fetch part of the chart XML, which still needs to be edited manually. Especially if you create charts that utilize relationships and N:N …

Contextual Power BI Reports on Dynamics 365 forms

I have mentioned on a few occasions that Power BI does not allow you to iframe its components. This means you cannot just add an iframe of a Power BI report inside Dynamics 365 on a customer form, for example. While Power BI does not allow this directly, the statement does come with an asterisk. …

More User based Charts in Dynamics 365

Last week I published a post on how to create a chart on the security roles for a list of users. It was one of those posts where I wasn't really sure in advance if I was the only one who would find it useful. Hence, I was very happy about all the positive feedback …

Chart your Security Roles in Dynamics 365

Sometimes it can be a little difficult to get a quick overview of who has got what security role in Dynamics 365. You either need to view the roles for each user manually, run one of the reports, or use a tool from the XrmToolBox. However, charts can also be used to get a quick …

Update: Custom Properties grouped in Advanced Chart Editor for the XrmToolBox

A new version of the Advanced Chart Editor for the XrmToolBox was just released, so make sure you have the latest version. (1.2018.1.14) A couple of bugs around pie charts has been fixed, so all the custom properties for pie chart should now display correctly. An issue with spaces in the custom properties section caused …

Use FetchXML in Power BI with Dynamics 365 customer engagement

I wasn’t really planning to write a post on this subject, but since this method helped me out significantly last week, I decided to write it up anyway. So first up, why use FetchXML to get data into Power BI when there is already the OData connection available. Well, FetchXML will give more filtering options, …