cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

Refresh fails, "canceled by user" "type mismatch" errors

I have a dataset in Power BI browser version queried from an Azure SQL database. The scheduled refreshes for this dataset all failed with the error "operation canceled by user." This was over the weekend and I haven't been near the database or Power BI so why would it think I canceled it?

On seeing the failures I tried refresh now. That failed too: "The following system error occurred: Type mismatch." There's no more information for me to know what exactly it's referring to as a mismatch so I don't know what I need to fix/change.

(I'm able to refresh this dataset in Power BI desktop when I click the refresh button.)

8 REPLIES 8
Highlighted
Super User IV
Super User IV

Re: Refresh fails, "canceled by user" "type mismatch" errors

Was the automatic refresh succeeding before and now it is not? Or was this weekend the first attempt?


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Power BI Team
Power BI Team

Re: Refresh fails, "canceled by user" "type mismatch" errors

Is it possible that the database schema has changed since the query was created?

Highlighted
Frequent Visitor

Re: Refresh fails, "canceled by user" "type mismatch" errors

I have exactly the same errors on two different datasets connecting to Dynamics CRM and Azure SQL, both work perfectly while running in Power BI desktop.

 

I don't know where to begin troubleshooting it really as the error message really doesn't tell me anything. Type mismatch=ok so is that some column somewhere having a wrong setting for datatype? Thats the best guess I can think of but here is no way of finding out what it refers to which column? which data source, needle in a haystack as it stands now. Most frustrating fact is that it works on the desktop where you could trace it and find out where the error came from...

Highlighted
Microsoft
Microsoft

Re: Refresh fails, "canceled by user" "type mismatch" errors

No, automatic refresh had never suceeded before. Refresh only succeeds in Power BI desktop

Highlighted
Regular Visitor

Re: Refresh fails, "canceled by user" "type mismatch" errors

Did you figure out this problem?/

 

I have the same case.. 

 

Please help..

Highlighted
Regular Visitor

Re: Refresh fails, "canceled by user" "type mismatch" errors

Did you figure out this problem?/

Highlighted
New Member

Re: Refresh fails, "canceled by user" "type mismatch" errors

Did you found a solution for this issue?

Highlighted
Community Champion
Community Champion

Re: Refresh fails, "canceled by user" "type mismatch" errors

I have had this happen to me in the past. It was tied in to a change in the database that my data was being pulled from. I opened the pbix desktop file and refreshed the query through the query editor. Re saved the file and and then opened powerbi.com. From there, I did a manual refresh and re set the scheduled refresh. I have not had a reoccurence of the issue since then.

I hope this helps you. Keep in mind that what worked for me may not work for you.



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors