When you use Power Query as an Excel-automation-tool rather than just to feed the data model, you might want to return clickable hyperlinks that carry friendly names. This doesn’t work out of (…) Read more
Posts Tagged ‘M’
How to create and use an R-function-library in Power BI
Edit 10-10-2017: There is also a (simpler) way to run a custom function library described here: http://www.thebiccountant.com/2017/10/06/create-a-function-library-in-power-bi-using-m-extensions/ . If you go that route, the only point of interest in the (…) Read more
Tips and Tricks for R scripts in the query editor in Power BI
Especially if you are new to R, there are some things one needs to know to successfully run R-scripts in the query editor of Power BI. I will share them (…) Read more
Should we pipe M?
“Just because you could doesn’t mean you should”… So I’m asking the Power Query and M fans & experts here if we “should” pipe M: Background: With M you can nest your (…) Read more
New M-function: Table.TransformColumnTypesToFirstRowsTypes for PowerBI and PowerQuery
The following function automatically transforms all columns to the types that have been detected in the cells of its first row. Provided they come as: Number, date or text (but (…) Read more
How to expand a column that cannot be expanded in Power BI and Power Query in Excel
Especially when working with JSON-data, you might end up with a column that has elements of mixed types in it. The expand column – arrows will be missing, but some elements still need (…) Read more