Forum Discussion
hybrid table not working
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 ?
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.
1 Reply
v-henryk-mstfCommunity Support
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.