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 in Category ‘Excel’
How to open a complex JSON record in Power BI and Power Query
Today I’ll show you a very useful technique how to deal with a JSON record that contains a wild mixture of different elements like this: If you click on one (…) Read more
How to import from Excel with cell coordinates in Power Query and Power BI
There might be occasions where you want to import data from Excel into Power Query or Power BI using cell coordinates like a range from E3 until G9 for example (…) 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
Table.TransformColumns – alternative in PowerBI and PowerQuery in Excel
This article shows a trick for a little problem that annoyed me for quite some time: How to get Table.TransformColumns transforming the values of a column with a reference to a value (from the (…) Read more