Forum Discussion

jessicaL_51's avatar
jessicaL_51
Frequent Visitor
3 years ago
Solved

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

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 ...
Need Help
jessicaL_51's avatar
jessicaL_51
Frequent Visitor
3 years ago

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