PowerQueryBuilder 1.2019.423.8

Power Query (M) Builder

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" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add PowerQueryBuilder --version 1.2019.423.8
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

20190423
-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
-Date formatting
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.

20181014
-Add Linked Entity
-Link with FetchXmlBuilder
20180720
-FetchXml feature has been added.

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.2019.423.8 5,878 4/23/2019
1.2018.1014.5 12,331 10/14/2018
1.2018.7.20 8,805 7/19/2018
1.2018.7.7 2,634 7/7/2018
1.2018.7.5 760 7/5/2018
1.2018.6.25 2,523 6/25/2018
1.2018.6.15 2,272 6/15/2018
1.2018.6.4 481 6/14/2018