Optimising OData Refresh Performance in Power Query for Power BI and Excel
OData has been adopted by many software solutions and has been around for many years. Most solutions are using the…
Archive
Category: Power Query
Incremental Refresh in Power BI, Part 1: Implementation in Power BI Desktop
Incremental refresh, or IR, refers to loading the data incrementally, which has been around in the world of ETL for…
Power BI 101, What Should I Learn?
This is the second part of my new series of Power BI posts named Power BI 101. In the previous…
Combining X Number of Rows in Power Query for Power BI, Excel and Power Query Online
A while back, I was working on a project involving getting data from Excel files. The Excel files contain the…