While I was tracing some Power BI datasets with Hybrid tables, I noticed that that the DirectQuery partition of a Hybrid table is used in all queries submitted to the Hybrid table, whether or not they are asking for data from that Direct Query partition. On first look, this does not look good because Power … Continue reading How does the DirectQuery partition of a Hybrid table in Power BI get used in queries?
Category: Hybrid Tables
Incremental Refresh and Hybrid Tables in Power BI
Here is a short video that shows you how to set up incremental refresh with or without the hybrid option in Power BI. https://www.youtube.com/watch?v=CDJ3s4v7Fsg&t=458s
A look at automatic partition maintenance by Power BI Service for datasets with Incremental Refresh
In this post, I am going to look at automatic partition maintenance by Power BI service for datasets with Incremental Refresh and focus on what happens to the partitions as time goes by. To do this, I am going to set up a couple of sample datasets with different Incremental Refresh (IR) policies with and … Continue reading A look at automatic partition maintenance by Power BI Service for datasets with Incremental Refresh