PowerQueryBuilder 1.2019.423.8

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.
#r "nuget: PowerQueryBuilder, 1.2019.423.8"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install PowerQueryBuilder as a Cake Addin
#addin nuget:?package=PowerQueryBuilder&version=1.2019.423.8

// Install PowerQueryBuilder as a Cake Tool
#tool nuget:?package=PowerQueryBuilder&version=1.2019.423.8
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

-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.

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

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.2019.423.8 25,510 4/23/2019
1.2018.1014.5 12,649 10/14/2018
1.2018.7.20 9,171 7/19/2018
1.2018.7.7 2,948 7/7/2018
1.2018.7.5 1,106 7/5/2018
1.2018.6.25 2,868 6/25/2018
1.2018.6.15 2,617 6/15/2018
1.2018.6.4 822 6/14/2018