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
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??

      • zoloturu's avatar
        zoloturu
        Memorable Member
        8 years ago

        noamo48,

         

        1. This information was requested by Microsoft. Not by me!

        2. I spent many hours on working with Microsoft on resolving different issues, sometimes Fiddler trace can show errors in http requests. I guess Microsoft can get it but it will take much time from them to select only your PC trace from thousands of others.

         

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