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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        I would probably suggest raising a ticket for this problem specifically.  I have encountered strange things from time to time and its possible the problem is quick technical on the Power BI Service side.  Generally when I have encountered these, raising this through the "issues" section has helped resolve the problem.  Sometimes the problems are on Microsofts side of the fence, and its worth getting them to look at it directly.