Menu
Our BI team is really growing to like the Power Query ETL tool used within Excel and Power BI. The functional language M/PowerQuery has great utility and it would be nice to be able to utilize outside of the context of PowerBI.
Is there or are there plans for exposing "M" as a stand-alone module, callable form the likes of c# or PowerShell?
828
As the name suggests, Power Query is the most powerful data automation tool found in Excel 2010 and later. Power Query allows a user to import data into Excel through external sources, such as Text files, CSV files, Web, or Excel workbooks, to list a few. The data can then be cleaned and prepared for our requirements.
Power BI Desktop > Home tab > Edit Queries > select one of your queries > View tab > Advance Editor. A new popup window will open with the M-code of the selected query. Power query has an easy to use and powerful GUI tool.
With Power Query, you can automate your report by creating a query that pulls data from all the files in a given folder to create a single data set. From this single data set, you can quickly create a PivotTable to summarize the transactions by general ledger account and by month.
Power Query has an incredible amount of features that are dedicated to helping you clean and prepare your data for analysis. You will learn how to simplify a complicated model, change data types, rename objects, and pivot data.
https://ideas.powerbi.com is probably the right place to post this. I've passed the link around internally, it will probably get some more upvotes at the minimum :)
I don't know of any official plan to have a public standalone library to invoke "M" from a different application, but that's what other Power BI products like the Power BI Gateway use to run "M".
Edit: OP created the idea here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16969474-make-powerquery-etl-a-scriptable-language-targetin
185
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
