Power Query (M) Builder

Description

Create Power Query (M) scripts for Dynamics 365 and Power BI

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

Versions

Version	Release date	Number of downloads	Rating
1.2019.423.8	4/23/2019 8:00:07 PM	44677	0.00
1.2018.1014.5	10/14/2018 12:19:34 PM	12853	0.00
1.2018.7.20	7/19/2018 9:29:20 AM	9427	0.00
1.2018.7.7	7/7/2018 12:06:47 AM	3171	0.00
1.2018.7.5	7/5/2018 10:33:19 AM	1349	0.00
1.2018.6.25	6/25/2018 11:40:15 AM	3164	0.00
1.2018.6.15	6/15/2018 10:22:13 AM	2852	0.00
1.2018.6.4	6/14/2018 2:07:01 PM	1070	0.00

Show more versions (3 more)

Ratings

Latest version

Other versions