Forum Discussion
GET request to SharePoint folder is slow
I am using the February 2020 release of PBI Desktop. All data loads into my report as Import / Scheduled Refresh. My report sources data from an Excel file that exists in a folder on SharePoint Onl...
Hi Anonymous ,
That really depends on numerous factors to be honest. For example. how big is your excel file? If that is hundreds of megabytes big then that will be slow (as it is downloaded in the background). Another issue can be the throtteling, based on how you connect to the excel file. Are you using the Sharepoint Folder connector? Or the Excel connector pointing to the Excel file? Other issue might be authentication?
Basically, it is very hard to pinpoint the problem exactly based on your description, but I hope some of the above suggestions might point you in the right direction?