Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
byeo
Regular Visitor

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. 

6 REPLIES 6
Anonymous
Not applicable

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.

 @Anonymous - Thanks for the suggestion. I tried but it is still throwing the same errorSmiley Sad

 

Anonymous
Not applicable

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.

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

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
Not applicable

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors