Forum Discussion
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
- v-jingzhangCommunity Support
Does this issue still occur?
- AnonymousNot applicable
v-jingzhang ,It works sometimes & sometimes It does not work. Not sure about the root cause.