If you’re working with large data or complex queries that take a long time refresh, cancelling one of those refreshes can even take longer time, especially, if the query has (…) Read more
Posts in Category ‘little Tipps&Tricks’
Query folding on JoinKind.Inner gotcha for Power BI and Power Query
If you query databases who support query folding, you’re probably very aware of every step you take and check if folding happens with every new step like so: Folding will (…) Read more
Bulk-extract Power Query M-code from multiple Excel files at once
Some time ago I published a function that extracts all M-code from Power BI (.pbix)-files. Today I publish the pendant to Bulk-extract Power Query M-code from multiple Excel-files at once. (…) Read more
Screenshot tutorial: Add a column with custom function code in Power Query
The following steps show how to create a new column in a table using existing custom function code. This works in Power BI as well as in Power Query in (…) Read more
Improve import of Excel sheets with empty rows and columns in Power Query and Power BI
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
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