Red Warning Icon Next to Dataset Refresh Data -- PowerBI Report no Longer Updates

Question

I get this error when I click the red warning icon next to my dataset.

Something went wrong

Please try again later or contact support. If you contact support, please provide these details.

Cluster URI: WABI-NORTH-EUROPE-redirect
Activity ID: 72bcab64-7024-4571-96a7-3244d5138f2e
Request ID: 242d44a2-be43-add5-2e37-a276bac89d1a
Time: 2020-07-07 13:37:54Z

Excel file on my desktop saves to onedrive fine, no errors on that end. But the data never gets to the PowerBI report, I keep getting the red warning icon next to the time/date the dataset was refreshed.

lbendlin · Answer

instead of web.contents try sharepoint.files or sharepoint.contents . Also try with API 14 instead of 15.

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,Due to the location of your data source changed, so please update it in Advanced Editor as below second screen shot. You can refer this documentation to get the file path in OneDrive.letSource = Excel.Workbook(Web.Contents("https://xxx.sharepoint.com/xxx/xxx/xxx/xxx.xlsx"), null, true),Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],#"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"ID", type text}, {"Name", type text}, {"QTY", Int64.Type}})in#"Changed Type"Local excel fileExcel in OneDriveBest RegardsRena

anonymous · Answer

I've only ever built/used the Power BI report on the webservice --&nbsp; do I have access to the advanced editor which seems to only be on the desktop version?