Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

refreshing from sharepoint folder very slow

Why does refreshing 1,1mln rows from csv on Sharepoint folder takes about 1hour, whilst refreshing the same data saved locally  takes 1min?
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks Jimmy

 

Let me add some thoughts. I repeated my tests after one month and got totally different results:

 

 

tests made in mid of Dec  (PBI Nov 2018 release) -> it takes +60min to import to pbi desktop

tests made in mid of Jan   (PBI Dec 2018 release) - > it takes about 5min to import to pbi desktop

 

I suppose big performance improvments in Dec 18 PBI desktop release. 

 

I have also tested the settings you suggested and here are results.

With my original settings I got exact time of 5min 24 sec to import data:

With a new settings I got 5min 09sek to import data:

It is not a big diff but it is something. :)

RichieRich's avatar
RichieRich
Icon for Advocate III rankAdvocate III
7 years ago

I am using the November 2018 version of desktop and experiencing refresh timeouts trying to load a csv file from SharePoint Online. The file has 17,000+ records and is 45Mb in size. I noted that this is bigger than the 30Mb that will open in Excel on-line. I opened the file and saved as an xlsx file in the same SharePoint folder. It now only takes a few seconds to refresh. The file size now though is only 2.25Mb in size. So it seems I can either wait for the organisation to update the desktop version, or change the csv files to xlsx.