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 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

Need Help

2 Replies

    • 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