cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
mindorf
Frequent Visitor

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

 

 

1 ACCEPTED SOLUTION

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

View solution in original post

7 REPLIES 7
v-huizhn-msft
Microsoft
Microsoft

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,
Angelia

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

@mindorfhi, how to set the culture?

Hi @Kelly_Zhu and @alexgs,

 

First of all @Kelly_Zhu I'm sorry for not replying earlier to you, i had not seen your post.

 

If i remember correctly, what you have to do is:

 

1. Open the PBIX file.

2. Go to the File menu -> Options and settings -> Options

3. Go to Regional Settings (under the "Current file" headline in the left menubar)

4. Change to English (UK) - at least that is what i did - others may work.

 

Hope this helps you.

 

Best regards,

Martin Mindorf

Hi Martin,

 

Thanks a lot!

 

Regards,

Kelly

I see just errors everywhere! Soo people now I want to create a feed-reader and search for the tickets to such wonderful shows like https://thecolorpurpleshow.com/ .Tickets to this show are hard to find, but if I created the feed-reader I would do it easy!

Hi,

 

Could you tell me how to change the culture?

 

Thanks,

Kelly

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors