Load Web Api Data Very Slowly - Stuck on 'Waiting for Server'

[jessicaL_51]

Hi,

I'm now having trouble loading data from the web API source to the Power BI desktop. 

To reduce the capacity of datasets, I set a date filter to the previous 12 months, which made the datasets shouldn't be huge.

However, I got stuck loading the data and cannot apply it to the Power BI desktop. (Screenshot attached below)

And does anyone have the idea of loading Web API data with pagination with a shorter waiting time?

I would appreciate your time and help.

 

Thank you.

Regards,

Jessica

[v-easonf-msft · Accepted solution]

Hi, @jessicaL_51 

Please check if the following thread could help.

https://community.powerbi.com/t5/Desktop/Slow-import-from-web-API/td-p/839232 

Best Regards,
Community Support Team _ Eason

[jessicaL_51]

Hi @v-easonf-msft,

Thanks very much for sharing the info above!

I have transferred my API data to excel, which reduces loading time from 10min to just a few secs.

By the way, I agree that it is important to remove unused columns, and only load some pages of data that you really need if anybody like me doesn't need data from decades ago... (Can operate the full capacity but not a good idea) 

Overall a very practical and good solution for integrating CRM and Power BI. 

Thanks again for your support.

Regards,

Jessica