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 5666 5.00
1.2018.1014.5 10/14/2018 12:19:34 PM 12331 5.00
1.2018.7.20 7/19/2018 9:29:20 AM 8805 4.00
1.2018.7.7 7/7/2018 12:06:47 AM 2631 0.00
1.2018.7.5 7/5/2018 10:33:19 AM 755 0.00
Show more versions (3 more)

Ratings

Latest version

(Ali Shoki, )
Dear Sir, I need to merge excel worksheets from multiple files in a single excel (master) file accordingly to their worksheet name. - If the worksheet already exists in the master file then it will insert (merge) data / rows below to existing data row in the master sheet or if not exist then will create new sheet and insert data as per source file rows. = It will not analysis /compare column title / header, but will - unhide all rows and column, copy and Paste Special Value from 1st row / column till end (row by row) from the source file to available lower cells of Master File like a manual task. - Delete blank rows, unhide all rows and column of the source file before copy. - While inserting each row, It will add file name in the first column. (similar to Microsoft Power Query). - There should have “Check” with number select option for how many rows escape from up / start from all source sheets (which is always “Header row / title”) while copy and pasting in the master file from source data. In short, simple and with only one above option, it should work as a manual system. Just copy from one sheet to master sheet without compare / any analyzing work. Hope you will help me to give a solution in this regard. Regards, Ali Khan alishoki@gmail.com

Other versions

(S. Irfan, )
What an amazing tool. God bless you all. Thanks soooo much for all your efforts.

(Scott Stamper, )
Really fantastic plugin! I know dual factor is in beta, but it would be great to have a bit more guidance and information on how to get it to work. Thanks! Scott

(Ben Hainsworth, )

(Jonny McMullan, )
Great tool. Promise me development for this particular plugin will continue. Makes reporting from Dynamics CE in Power BI so much more fluid.

(Marianne Lilholt Christensen, )
Great tool. First release tested. Maybe you should specify how to create the SourceURL.

Related information

Author: Mohamed Rasheed (ITLec) and Ulrik “CRM Chart Guy” Carlsson (Elev8 Solutions) Latest version: 1.2019.423.8 Released on: 04/23/2019 Nuget package Id: PowerQueryBuilder Open Source: true Go to project web site Ratings (all versions) 4Average rating 6Number of ratings Downloads 5666Latest version 35455All versions 4431.88Average per version