Forum Discussion

qihuiyu's avatar
qihuiyu
Regular Visitor
4 years ago

Incremental Refresh with Odata

We are currently working on a Odata - Power BI based reporting solution for our clients. We would like to make Incremental Refresh works on our odata connector.   I found this post https://communi...
Need Help
qihuiyu's avatar
qihuiyu
Regular Visitor
4 years ago

Hi, we tried the following query:

let
Source = Odata.Feed("https://server/odata/TimeSeriesRawResults"),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type datetime}}),
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each [Date] >= RangeStart)
in
#"Filtered Rows"

 

However on the sever log we dont see pbi sending request with $filter dates. 

 
  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    You need both RangeStart and RangeEnd, and they need to be included as filters in your ODATA feed URL, not in subsequent steps.