Forum Discussion
Using incremental refresh with OData - slow
When I attempt to use Incremental Refresh with an OData source, I get the following error regarding query folding: "Unable to confirm if the M query can be folder. It is not recommended to use in...
Thanks both. I had indeed read that article - it mentions 'typically', how can I find out if my OData feed is/is not able to fold with Incremental Refresh?
Hi thisisausername ,
The easy way is to set a small incremental range and try to do a incremental refresh, if it supports Query Folder, it should take much less time than full-size refresh. But it should test carefully such as limit the total rows because the process may run out of resources either in the Power BI service or in the on-premises data gateway if it does not support Query Folder.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.