[DataSource.Error] The request was aborted

[qmestu]

Hi,

I have the following error on loading of my data on the Power BI Desktop App:

OLE DB or ODBC error: [DataSource.Error] The request was aborted: The request was canceled..

This happens without me cancelling anything. I believe this might due to some restrictions on the side of Web API where i'm trying to get the data from, as it only occurs sometimes. I'm trying to load several tables that are then combined into one single table with about 20 million records. I've tried to disable paralell loading, loading one table at a time and tried the opposite, loading 10 tables, but neither of them worked.

Thanks for any help.

[amitchandak]

@qmestu , is it possible to paginate the report and load data

https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78

https://datachant.com/2016/06/27/cursor-based-pagination-power-query/

[qmestu]

Thanks, but this doesn't apply to my app. I have several URLs with several parameters.