If you’re using the native Oracle connector in Power Query, you will probably experience a very slow import performance. Thanks to Tristan Malherbe for recommending to use the OleDB-connector in (…) Read more
Posts Tagged ‘Performance’
Performance tip to speed up slow pivot operations in Power Query and Power BI
Pivot operations in are a very handy feature in Power Query but they can slow down refresh performance. So with some bittersweet pleasure I can tell that I found a (…) Read more
Performance tip for aggregations after joins in Power Query and Power BI
This article was edited on 2nd Nov 2019. JoinKind.Local has been removed to avoid problems with merges on tables with primary keys: In this article you’ll learn how to speed (…) Read more
Memory efficient clustered running total in Power BI
Today I want to share a scenario where a running total calculation in the query editor saved a model that run out of memory when done with DAX: Problem The (…) Read more
Performance tip for List.Generate (1): Buffer your tables in Power BI and Power Query
Lately I was working on a fairly advanced allocation algorithm on large data which forced me to search for different tricks to improve performance than those that you can find (…) 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