Is Hybrid Mode (Import + Direct Query) compatible with Data Explorer (Kusto)?

[Anonymous]

Hi all!

I have a table million of rows which is being fed by Azure Data Explorer (Kusto). In order to improve performance, I'd like to set incremental refresh for this table and also apply Direct Query to get the data from the current day. I've configured Incremental Refresh in my table as the following image shows, but my data doesn't change (and I know that new rows for the current day are being sent in Data Explorer)

What am I doing wrong? 😞 

Thanks for your help.

[v-yueyunzh-msft · Accepted solution]

Hi, @Anonymous 

First, incremental refreshes need to be published to Power BI Service for the refresh to take effect.
Secondly, the data used by incremental refresh in the relative time of "within a day" or "within a week" is published to the service to trigger the refresh is the time of the UTC0 time zone, you can combine your current local time zone to check whether the time zone is the reason why the data in your table has not changed after the incremental refresh?

For more information, you can refer to :

Solving DAX Time Zone Issue in Power BI - RADACAD

Also, for your problem, you can also try using SSMS to connect your workspace to see if the partitions created when your dataset is refreshed meet your needs.

For more information, you can refer to :

Advanced incremental refresh and real-time data with the XMLA endpoint in Power BI - Power BI | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly