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 types. The tool automates the field selection and the initial data transformation steps that normally has to be done manually.
With the latest version supporting FetchXML, the tool can now import the labels for option sets and lookup fields directly. That means creating additional transformations or DAX formulas are no longer needed just to show the proper label of an option set.
Here’s the latest video showing the updated features.
For more information and credits to everyone involved in this project, please check out the Power Query Builder page for full details. That page will also be continually updated with the latest updates on the tool.
Enjoy. As always, please sign up for my newsletter or follow me on Twitter Follow @CRMChartGuy