Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Issue with SharePoint Connection & Slowness in Report Refresh

Hi Team,

 

 I have connected Power Bi with Sharepoint Folders & I am getting below error since last 2 days on Power BI Desktop.

 

Error Msg:

An error occurred in the ‘L3 Digital’ query. DataSource.Error: SharePoint: Request failed: https://pgone.sharepoint.com/sites/MidwestRegionTeam/Shared Documents/Meijer Team/Dashboard360/eComm/raw_data/L3_Digital/we20201107_Digital Shopping Report - L3 Digital_xlsx/_api/contextinfo
Details:
DataSourceKind=SharePoint
DataSourcePath=https://pgone.sharepoint.com/sites/MidwestRegionTeam
SPRequestGuid=d49a959f-0013-b000-ada7-25d9cf0d5e28

 

 

If I apply 'Refresh Preview' 7-8 times then it is working fine. But it is taking long time to refresh. Could you please help me with this?

 

Following Steps Tried:

1.Upgarded Power BI Version

2.Created in same queries in New PBIX file

3.Clear the Permission for Data Source and Reconnected.

4.Disabled Parellel Data loading option.

 

Thanks in Advance!

 

Rupesh

2 Replies