When you import Excel sheets who have empty leading or trailing columns and rows (showing null-values), you can substantially improve the complexity and speed of your import process with a (…) Read more
Posts in Category ‘Power Query’
Fast and easy way to reference previous or next rows in Power Query or Power BI
When you search the web for solutions to reference previous or next rows in the query editor of Power BI or Power Query, you will find many solutions that base (…) Read more
Efficiently rename columns with a function in Power BI and Power Query
Edit 2018-July-05: As it turns out I’ve missed the native function that exists with exact the same functionality: Table.TransformColumnNames Thanks to Tristan Malherbe for pointing this out 🙂 But anyway: (…) Read more
Automatically expand all fields from a JSON document in Power BI and Power Query
If you work with JSON documents that are new to you, it can be very helpful to fully expand JSON to see at a glance what’s in there. The following (…) Read more
Easy POST requests with Power BI and Power Query using Json.FromValue
The function Json.FromValue provides a super-easy way to create POST-calls to web services that require JSON format in their body parameters. Background If you want to make a POST request (…) Read more
Import data from multiple SharePoint lists at once in Power BI and Power Query
This is a quick walkthrough on how you can easily import multiple SharePoint lists at once, just like the import from folder method. Start as usual You start your import (…) Read more