hybrid table not working

[powerbiastra1]

My source is an oracle view

I have configured incremental refresh, and I am trying to use hybrid table concept but get the latest data in real time option is disabled for incremental refresh

Also, the view native query in the applied steps is disabled, is the "get the latest data in real time option" disabled because of query folding problem ? If so why query folding not working for oracle view ?

[v-henryk-mstf · Accepted solution]

Hi @powerbiastra1 ,

The reason why the button does not work is because incremental refresh and Hybrid tables cannot work together.

refer to this similiar solution:

Incremental refresh and Hybrid tables - Microsoft Power BI Community

The following requirements need to be met to use query folding.

refer to below document:

Query folding guidance in Power BI Desktop - Power BI | Microsoft Learn

Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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