Forum Discussion
Hybrid tables hits Direct Query though the Query mode is selected as Import for Hot data partition
Hi Team,
I was working with Hybrid tables and was able to create the hot data and cold data partitions.
Post that I refreshed the hot data partition and again connected to this POwer BI dataset in Desktop and built a table visual along with a slicer.
But one thing I noticed that though I filter out data which is actually a part of hot data partition it still hits the Direct Query (seen under performance analyzer). Is this a bug? Does that mean though we select import query for Hot data partition, import query never runs or comes into picture? Is it only the direct query that works?
Check this article, Scenario #2
Hybrid tables in Power BI - The ultimate guide! - Data Mozart (data-mozart.com)
2 Replies
- lbendlin
Super User
Check this article, Scenario #2
Hybrid tables in Power BI - The ultimate guide! - Data Mozart (data-mozart.com)
- AnonymousNot applicable
Hi Ani26 ,
Does lbendlin 's answer is useful? If so, please kindly mark lbendlin 's answer as a solution. If not, please provide more details with the issue.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly