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

Update: Add MarkerStyles and Nodes with the Advanced Chart Editor for the XrmToolBox

A few new updates have recently been released for the Advanced Chart Editor for the XrmToolBox. We hope you like them. This blog post details the updates in version 1.2017.8.29. If you are new to the Advanced Chart Editor, check out this blog post. Save button Save button now understands if you are working on … Continue reading Update: Add MarkerStyles and Nodes with the Advanced Chart Editor for the XrmToolBox

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

Edit Charts in the XrmToolBox for Dynamics 365

For the past months I have been collaborating with Mohamed Rasheed on a plugin for the XrmToolBox. We are pleased to announce that it is now available. The plugin, which can be downloaded from the plugins store is called "Advanced Chart Editor" and it lets you modify the chart XML in Dynamics 365 (and Dynamics … Continue reading Edit Charts in the XrmToolBox for Dynamics 365

Record Specific Power BI Reports in Dynamics 365 (only one click away)

I recently returned from a trip where I traveled around Europe teaching Business Intelligence and Power BI for Dynamics 365 and finished it off with a number of presentations at eXtreme365 in Lisbon. First of all, a huge thank you to all the people who attended my sessions and all the great questions that followed. … Continue reading Record Specific Power BI Reports in Dynamics 365 (only one click away)

Prefilter data for Power BI with OData URLs

When you connect Power BI to Dynamics 365, it pulls all the records from the entities that you have selected. That is generally a good thing, but there are situations where that is very inconvenient. Maybe you are dealing with large datasets, or you need to filter what records are available for security purposes. If … Continue reading Prefilter data for Power BI with OData URLs