Issue with SharePoint Connection & Slowness in Report Refresh

[Anonymous]

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

[Anonymous]

@v-jingzhang ,It works sometimes & sometimes It does not work. Not sure about the root cause.

[v-jingzhang]

Does this issue still occur?