Duplicate requests for OData feed in PowerBI desktop

[sivakumar1]

 While trying to load data using OData feed, PowerBI is triggering multiple requests. For every fetch it is triggering more than 4 duplicates calls. 

And,

If we don't specify the limit in the query, then it never ends, looks like in a infinite loop. Due to this I couldn't use it.  Is this an existing bug in PowerBI? Any solution for this?

[v-haibl-msft]

@sivakumar1

I have not seen such issue before. If you don't specify the limit in the query, are you able to load data successfully?

Could you please provide a sample data source which can be used to repro?

Best Regards,
Herbert

[sivakumar1]

Thanks for the reply.

This is what happening when we don't specify limit

1) request is being sent to my server to fetch data

2) I have a default limit specified to 5K. So, it is fetching first 5K records and sending another request with $skiptoken = last_record_identifier 

3) I implemented to handle $skiptoken from my OData feed. So, it sends requests until I don't have any more records to fetch

This is fine as long as I have data and I don't specify limit

But, when we specify limit, I see multiple requests  (from PowerBI Desktop)

These are the requests triggering when we I try to fetch 5K records

Access log

First 3 requests to show a small popup in PowerBI Desktop before loading the data

Next 4 requests to load 5K records in to PowerBI Desktop