Forum Discussion

pnussbaumer's avatar
pnussbaumer
Frequent Visitor
7 years ago

Scheduled Refresh not working - always another error message

Hi all,   since days I try to figure out why my "Scheduled Refresh" is not working. The error message is always the same like "The command has been canceled. Table: Core: Currencies" - always anoth...
Need Help
pnussbaumer's avatar
pnussbaumer
Frequent Visitor
7 years ago

Dear Gilbert,

 

thanks a lot for your feedback. Very appreciated.

 

Thats the whole message BUT the Table where it should happen is always another. So I got the same message with the Table  "ABC", "XYZ", etc. 

 

Last refresh failed: Fri Feb 15 2019 09:38:18 GMT+0100 (Central European Standard Time) 
There was an error when processing the data in the dataset.Hide details

Message:The command has been canceled. Table: Finance: Revenue Targets.
Cluster URI:WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:3089d1fe-e9ae-4fe9-9327-79a2e60c9bab
Request ID:ea610e85-e0ed-476d-8d1f-554bb9b822af
Time:2019-02-15 08:38:18Z

 

I am running the latest PBI Desktop I think: 2.65.5313.841 32-bit (December 2018)

Oh, and very important: I don't use a gateway. The documents are all on SharePoint Online in a library. No on-premise.

 

Thank you,

philip

  • pnussbaumer's avatar
    pnussbaumer
    Frequent Visitor
    7 years ago

    Hi Gilbert, thanks again.

     

    I don't use a SharePoint-List as a Data Source. I go over "Excel.Workbook" and then over "Web.Contents" and there I don't have an API-Version.

     

    Source = Excel.Workbook(Web.Contents("https://XYZ.sharepoint.com/sites/XYZTEa,/Shared%20Documents/XYZFolder/Core%20Data.xlsx"), null, true),

    Calendar_Sheet = Source{[Item="Calendar",Kind="Sheet"]}[Data], #"Promoted Headers" = Table.PromoteHeaders(Calendar_Sheet, [PromoteAllScalars=true]), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date", type date}, {"Quarter", Int64.Type}, {"FinancialYear", type text}, {"Day", Int64.Type}, ...

     

    I think that should work like this, no?

     

    Thanks,

    phil

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      7 years ago

      Hi pnussbaumer 

       

      Yes that is how it should work.

       

      Could I ask if you had to try and access the file directly would it work or not work?

      • pnussbaumer's avatar
        pnussbaumer
        Frequent Visitor
        7 years ago

        Hello back,

        I thought the same... 

        Yes, I have definitively access to it. I tried with many accounts; I even tried to give access to the files on SharePoint to the Account where I published the report from the Desktop.

        The weird thing is that under "Data source credential" is all "good" in the sense that there is no cross icon or so.

        Any other idea? :-)

        Thanks,
        phil