Forum Discussion

mindorf's avatar
mindorf
Frequent Visitor
8 years ago
Solved

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...
Need Help
  • mindorf's avatar
    mindorf
    8 years ago

    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

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

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

mindorf's avatar
mindorf
Frequent Visitor
8 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi,

     

    Could you tell me how to change the culture?

     

    Thanks,

    Kelly

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    mindorfhi, how to set the culture?

    • mindorf's avatar
      mindorf
      Frequent Visitor
      7 years ago

      Hi Anonymous and Anonymous,

       

      First of all Anonymous 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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Martin,

         

        Thanks a lot!

         

        Regards,

        Kelly