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 desktop and the error is only when trying to refresh from PowerBI service. 

 

The data source is excel online in a Sharepoint. There is no calculated column involved and it is a very straightforward pointing to excel online to create some visualization in PowerBI.

 

The size of excel file is ~45 KB and pbix file is ~480 KB.

 

Any suggestions what might be the root cause for this error?

 

Thanks

6 Replies

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