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

      • boardstat_beta's avatar
        boardstat_beta
        Regular Visitor
        8 years ago

        I more or less have the same issue with PowerBI service. 

         

        PowerBI desktop and Excel can download the data with credentials, but PowerBI service times out because it can't refresh the credentials.