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

[Anonymous]

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.

[yingyinr]

Hi @Anonymous ,

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.

let
Source = 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 OneDrive

Best Regards

Rena

[Anonymous]

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

[lbendlin]

Sorry to hear that.  I think it's only on the desktop version.

[lbendlin]

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