Create Power Query (M) scripts for Dynamics 365 and Power BI
Install-Package PowerQueryBuilder -Version 1.2019.423.8
dotnet add package PowerQueryBuilder --version 1.2019.423.8
<PackageReference Include="PowerQueryBuilder" Version="1.2019.423.8" />
paket add PowerQueryBuilder --version 1.2019.423.8
-Inclusion of all entities
-Errors when generating queries based on custom FetchXML with entities not available in Advanced Find has been fixed. It is now possible to pass any query generated in the FetchXML Builder to the Power Query Builder, either manually or using the integration.
-RelativePath in web.content calls
We have added the use of RelativePath to the web.content calls. Whereas the current setup would create a connection for each entity in the Power BI service, using RelativePath will reduce it to only one connection that needs to be maintained for refreshes etc.
Big thanks to hanksteen on GitHub for the suggestion. https://github.com/ITLec/PowerQueryBuilder/issues/26
The current transformations for custom date and time fields, formatted as date only, would generate errors. We have changed all the date fields to only retrieve the formatted value via the FetchXML, which fixes this error. The added benefit is that all dates and times are now retrieved in the users local time zone rather than UTC. Data still includes time zone details.
-Add Linked Entity
-Link with FetchXmlBuilder
-FetchXml feature has been added.
- XrmToolBox (>= 1.2017.3.14)
This package is not used by any popular GitHub repositories.