Forum Discussion
Error refreshing: The command has been canceled.
I get the following error on my dataset in the web version of Power BI (also emailed to me):
Message: The command has been canceled.
Klynge-URI: WABI-EUROPE-NORTH-B-redirect.analysis.windows.net
Aktivitets-id: e95e0d70-4376-4d69-9dd2-9691984d0257
Anmodnings-id: 1171d5ce-e40b-4701-a68d-5089d021ed76
Klokkeslæt: 2017-09-13 14:07:53Z
The error does not occur in the Desktop application.
I have two data sources: one SQL database (around 20.000 rows) and one https JSON feed (60 rows).
No other error information is available. Not very helpful.
Best regards,
Martin
Hi Angelia,
Thank you very much for your reply.
This would have been the next step for me, however, after much debugging and frustration, i found the reason.
To resolve the problem, i created a copy of my workbook and then started removing data sources one at a time.
Finally, after removing some of the tables, the error message became more meaningful: "The specified culture is not supported.. The exception was raised by the IDataReader interface."
I reopened my copy of the original workbook. I had set the culture to English (Denmark). After changing this to English (UK) and refreshing data sources + republishing everything works fine.
I don't know why the original error message masked the real error before. I did nothing in the original workbook other than changing the culture. So it must have been the same error, just not surfacing correctly.
I hope this helps someone else with the same problem.
Best regards,
Martin
7 Replies
Hi mindorf,
You get data from SQL Server database and JSON file, create report in Power BI desktop. Then you publish it to Power BI service, right? If it is, if you install data gateway and add data source in gateway?
I post the following articles for your reference, hope they are helpful.
On-premises data gateway
Manage your data source - SQL Server
Don't hesitate to ask if you have any other issues.
Best Regards,
AngeliaHi Angelia,
Thank you very much for your reply.
This would have been the next step for me, however, after much debugging and frustration, i found the reason.
To resolve the problem, i created a copy of my workbook and then started removing data sources one at a time.
Finally, after removing some of the tables, the error message became more meaningful: "The specified culture is not supported.. The exception was raised by the IDataReader interface."
I reopened my copy of the original workbook. I had set the culture to English (Denmark). After changing this to English (UK) and refreshing data sources + republishing everything works fine.
I don't know why the original error message masked the real error before. I did nothing in the original workbook other than changing the culture. So it must have been the same error, just not surfacing correctly.
I hope this helps someone else with the same problem.
Best regards,
Martin
