Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Incremental Refresh with OData

Hello Everybody,

 

is it possible to make incremental refresh work with Odata? So far I havent found a way to make things work. No matter how much I try the filtering of an Odata Query is not folded to the source. I first tryed Query Folding with a simple Query for an Entry_No not even aiming for the paramters or dates.
I use the Query Diagnostics to trace if the Query send to the server is parametrized but it is not.

 

Example:

let
Source = OData.Feed("SourceURL"),
VendorLedgerEntries = Source[VendorLedgerEntries],
#"Filterd Rows" = Table.SelectRows(VendorLedgerEntries, each ([Entry_No] = 8857))
in
#"Filterd Rows"

 

This results only in the following Query send to server:

 

Request:
GET http://SourceURL/VendorLedgerEntries HTTP/1.1

Response:
http://SourceURL/VendorLedgerEntries
HTTP/1.1 200 OK

 

The only time this does work is when I set the parameter myself in the Query, however then it will not work in the service.

 

Example:

let
Source = OData.Feed("SourceURL/VendorLedgerEntries?$filter=Entry_No eq 8857", null, [Implementation="2.0"])
in
Source

 

=> This is what I would like to see in the previous example in my Query Diagnostics

 

Is there any way of Query folding in Odata at all? If so how to make use of it?

And is it possible to use the Parameters RangeStart and RangeEnd with Odata for incremental refresh?

 

Help would be appreciated 😄

 

1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

Hi @Anonymous 

It is a limitation currently as the data sources doesn't support query folding.

Please check the workarounds below:

https://thinkaboutit.be/2020/02/how-do-i-implement-an-incremental-refresh-in-power-bi-free-or-pro/

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-juanli-msft
Community Support
Community Support

Hi @Anonymous 

It is a limitation currently as the data sources doesn't support query folding.

Please check the workarounds below:

https://thinkaboutit.be/2020/02/how-do-i-implement-an-incremental-refresh-in-power-bi-free-or-pro/

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Is it still an issue ?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors