Forum Discussion

byeo's avatar
byeo
Regular Visitor
8 years ago

There was an error when processing the data in the dataset. The command has been canceled.

We have a dashboard that was working fine with scheduled data refreshes for few weeks but it now started failing when refreshing from PowerBI service. There is no issue refreshing from PowerBI deskto...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

As a simple test. Download the project out of the service, rename it and upload it again.  This will give you a newly published clone of your report.  Set up any gateways for this clone and attempt a refresh.

 

I had a report recently that had a similar issue and it seemed to be a corruption in the version on the Service.  Publishing over the top did not resolve the problem and I had to resort to removing it and republishing it.

  • byeo's avatar
    byeo
    Regular Visitor
    8 years ago

     Anonymous - Thanks for the suggestion. I tried but it is still throwing the same error:smileysad:

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      What happens if you refresh using the Power BI Desktop?  Do you get more information on the error?  With Excel, sometimes changes made to the file can be just enough to break your import logic.

      • byeo's avatar
        byeo
        Regular Visitor
        8 years ago

        When refresh from PowerBI Desktop, there is no error at all! I am able to see new data coming in from Excel and I am also able to publish to web successfully. Do you know where I can check out "log file"  in PowerBI Desktop? Maybe I can get some hint from there...