Forum Discussion

Ani26's avatar
Ani26
Icon for Helper III rankHelper III
4 years ago
Solved

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?

2 Replies