cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

OData feed with incremental refresh not refreshing

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.)

 

Itzarthi_2-1607348708098.png

 

 
 

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

Itzarthi_3-1607348764993.png

 

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.

 

 

1 REPLY 1
Community Support
Community Support

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

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors