Desktop Refresh Issue

[ArchStanton]

Hi,

Everytime I try and refresh my report in PowerBI Desktop I am greeted with this message which appears after 5-10mins of evaluating and trying to create a data connection to the model.

Each time this happens I lose a lot of time before I re-connecting, only then do I see the Refresh screen:

Does anyone know why this is happening and what I can do about it? 

The report is massive, 15GB in size so it takes a good 20-30mins to refresh as it is, and thats without the wasted 5-10mins for the first message.

Thanks

[ArchStanton]

Thank you!

[lbendlin · Accepted solution]

Don't use the Web connector for SharePoint content. Use the SharePoint Folders connector.

[ArchStanton]

Hi,

All three options require a URL to the Sharepoint folder, I'm already using the Sharepoint Folder option with the URL below

= Excel.Workbook(Web.Contents("https://xxxx.sharepoint.com/sites/CEI/Documents/Management%20Information%20and%20KPIs/Adhoc/

I'm not sure what to do? 

Can you help?

[lbendlin]

Use SharePoint Folder with "https://xxxx.sharepoint.com/sites/CEI"