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 … Continue reading Power Query Builder updated – now supports FetchXML to get your Dynamics 365 Views into Power BI

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 … Continue reading Duplicate Detection Rules Chart in Dynamics 365

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 … Continue reading Use the FetchXML Builder to help create charts in Dynamics 365

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 … Continue reading Chart your Security Roles in Dynamics 365

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, … Continue reading Use FetchXML in Power BI with Dynamics 365 customer engagement

Updates to the Advanced Chart Editor for the XrmToolBox

A set of new features are now available for the Advanced Chart Editor for the XrmToolBox. You can find an introduction video for the Advanced Chart Editor here. Here is that we have been working on in the latest release aside from a few bug fixes: Help text for the properties Most of the properties … Continue reading Updates to the Advanced Chart Editor for the XrmToolBox

Color options and create a custom color palette for the Chart Editor in the XrmToolBox

The charts in Dynamics 365 supports four different types of colors and 12 different system color palettes, outside of the custom palette that Dynamics 365 uses by default in its charts. In this video I'll go through how to work with those four different types of colors in the Advanced Chart Editor plugin for the … Continue reading Color options and create a custom color palette for the Chart Editor in the XrmToolBox