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 r...
Need Help
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

    • zoloturu's avatar
      zoloturu
      Memorable Member
      8 years ago

      Hi noamo48,

       

      I can explain.

       

      1. Open Fiddler and start trace.

      2. Run refresh of dataset(s) in Power BI Service.

      3. Wait until refreshed.

      4. Save Fiddler trace as file.

       

      Let me know if you need more detailed description.

       

      Regards,

      Ruslan

      -------------------------------------------------------------------
      Did I answer your question? Mark my post as a solution!

       

       

      • noamo48's avatar
        noamo48
        Frequent Visitor
        8 years ago

        Ruslan, how is that going to help? What info will you get from MY computer when the refresh happens on MICROSOFT'S servers??