Forum Discussion
refreshing from sharepoint folder very slow
Anonymous,
Try clicking Options-> Data Load-> Unclick all the options in Background Data, Time intelligence and Relationships, do click the Parallel loading of tables like below:
Regards,
Jimmy Tao
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. :)
- I'm experiencing the exact same issue: it's taking a very long time to load a 1.5 million rows csv file. I can't convert it to xls because it's too large. How is your file performance with the latest pbi update (Apr 19)?
I started to compress csv files to csv.gz
It gives significant reduction in size and loading times.
With some tricks Power BI can connect to such file.
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.
