Forum Discussion

noamo48's avatar
noamo48
Frequent Visitor
8 years ago

Scheduled refresh failure message: The command has been canceled

I have four PBIX files with identical datasets but different tabs. They are pulling data from CSV files stored in a Sharepoint site. I have it scheduled for nightly refresh.

 

For only one of the reports the refresh ALWAYS fails! And every single time it fails, I get this error but with a different table name each time:

Last refresh failed: Thu Jul 19 2018 21:55:12 GMT-0400 (Eastern Daylight Time)
There was an error when processing the data in the dataset.Hide details
Message: The command has been canceled. Table: TABLENAME.
Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID: 664f410a-8c87-54fb-7d89-b354535b69ff
Request ID: c443529f-e293-433e-e1fb-921456021b14
Time: 2018-07-20 01:55:12Z

I want to reiterate that it's a different table causing the error every time. When I open the report in Power BI Desktop, it loads just fine. I'm able to refresh everything in the dataset. Although one of the 22 queries contains 258,000 rows and one single error (which I can't track down for the life of me). 

 

What the heck is going on with this? How can I get this refresh to work? Why is it only failing for this one specific report despite the datasets being identical across all 4 of them?

Need Help

9 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    Are they all pulling from the same CSV file? If so, I wonder if there is some kind of locking issue going on? If you have a Pro license, you can open a support ticket for this. I would submit this as a support issue. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

    • noamo48's avatar
      noamo48
      Frequent Visitor
      8 years ago

      Hi,

       

      There are the same, identical 22 queries all pulling from the same set of 12 CSV files in all four datasets. The only difference in the PBIX files is which tabs they contain. 

       

      I thought it was just one dataset failing to refresh, but now it seems all four datasets are having issues refreshing. But it only happens intermittently. If I try to manually refresh any dataset it will throw an error every time about a different table. But eventually it does refresh successfully. Makes no sense...

       

      I have a Power BI Pro license so I'll try opening a support ticket I guess...

      • noamo48's avatar
        noamo48
        Frequent Visitor
        8 years ago

        Well Microsoft support has been super helpful so far....they asked me to run a Fiddler trace on the dataset refresh! :D How can I run a Fiddler trace on Microsoft's servers during the dataset refresh? Can anyone answer that? SMH