Forum Discussion

scaramangamp's avatar
scaramangamp
Frequent Visitor
9 years ago

Slow PowerBi Desktop Refresh

Hi,   I have a PowerBI file with 10 data sources, some Web, some ODBC some local files. The Web files are very large (40MB) however I only select a few columns. There are till 30,000 + rows.   W...
Need Help
scaramangamp's avatar
scaramangamp
Frequent Visitor
9 years ago

Hi all,

 

I am a desktop file with a few different data sources:

  • Web files (mainly)
  • ODBC
  • Local files

 A couple of files are big at source (40MB) however using the query editor I am only taking about 15% of this.

They have around 30k+ rows or more.

 

The problem I am encountering is not the time to download the data (only it has downloaded the first row) but the time to start downloading, from when I pretty the 'refresh all' button it can spend up to 2 hours with the pop up just showing each dataset is "Waiting for other queries..." or "Evaluating". It sometimes then fails with a query problem, othertimes it starts to download.

 

When scheuling a refresh (using the gateway) if it succeeds it takes about 30mins.

 

I have tried playing around with the 'Data load' settings as suggested in a solution to a similar problem but to no avail. 

Would very much appreciate any assistance. Thanks.