Forum Discussion

thisisausername's avatar
thisisausername
Icon for Helper II rankHelper II
6 years ago

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...
Need Help
thisisausername's avatar
thisisausername
Icon for Helper II rankHelper II
6 years ago

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?

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

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.