Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

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. Cluste...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      lbendlin
      Icon for Super User rankSuper User
      6 years ago

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