OData feed with incremental refresh not refreshing

[Itzarthi]

Hey Guys,

I have a Power BI report based on Odata feed of Dynamics. In this report I have defined the following parameters: RangeStart and RangeEnd. On the table I had the possibility to turn on incremental refresh. But when uploading it to the Power BI services I can't find the parameters: 

(Translated in ENG: No parameters have been defined yet for this dataset. To set parameters, use the Query Editor.)

I thought I just try to refresh it, but the following error comes up:

Can anyone help me how to fix this? Because the dataset is to large for Power BI services and takes more than 120 minutes to refresh and I don't know how to fix it else.

[v-easonf-msft]

Hi， @Itzarthi 

Odata feed of Dynamics doesn't support query folding.It is not recommendeded to use incremental refresh with non-foldable queries.

It is suggested to use the Query Diagnostics feature, or trace queries received by the source database to  check whether  the necessary query folding is occurring and the query send to the server is parametrized.

You  can refer to  these related  thread:

https://community.powerbi.com/t5/Service/Incremental-Refresh-Parameters-in-Service/td-p/1073459 

https://community.powerbi.com/t5/Power-Query/Incremental-Refresh-with-OData/m-p/968901

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh#query-folding 

Best Regards,
Community Support Team _ Eason