Hybrid tables hits Direct Query though the Query mode is selected as Import for Hot data partition

[Ani26]

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?

[Anonymous]

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

[lbendlin · Accepted solution]

Check this article, Scenario #2

Hybrid tables in Power BI - The ultimate guide! - Data Mozart (data-mozart.com)