Forum Discussion

ElpatoDBA's avatar
ElpatoDBA
Icon for Helper II rankHelper II
6 years ago
Solved

Query Changes error

Hi guys   I have applied supposedly an upgrade over Power Bi Desktop, I have downloaded the "latest" version without realising that version coming up in Spanish. I applied all and start to work nor...
  • ElpatoDBA's avatar
    ElpatoDBA
    6 years ago

    Hi guys!

     

    I could not fix my problem, logically. I have resolved to start again with a new file in the English version and start a massive copy and paste of queries and re-draw my reports. Queries and graph start to work again and everything looks like normal. I leave this case here documented but I don't know the reason.

     

    lesson learnt: Don't install upgrades from Microsoft Store and be careful if you have two different languages set in your environment in the cloud and locally.

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi ElpatoDBA ,

 

I encountered this error for the first time.

It seems that there is a problem with certain M queries.

Did the software report an error in 'Edit Query'?

Please check the M codes of the tables that cannot be loaded in ‘Advanced Editor’.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

MitchM's avatar
MitchM
Icon for Resolver II rankResolver II
6 years ago

I have seen this as well. Did you by chance change the name of your query from Query 1 to something else after loading the data? I did and I got the same error. By discarding this change of name and reverting back to Query 1 I resolved the issue.

  • ElpatoDBA's avatar
    ElpatoDBA
    Icon for Helper II rankHelper II
    6 years ago

    Hi Mitch,

     

    Thanks for your reply back. No, I did not change anything with queries, the story in short words, I wanted to install an updated for Power BI but I finished up with two versions of Power BI, one of them in Spanish. I started to work with the Spanish one, when I've started to notice that some graphics do not show properly is when my eye starts to put more attention to some much details. Deinstalled the Spanish version and my nightmare kicked-off.

     

    Regards;

     

    Jairo Suarez

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      6 years ago

      ElpatoDBA - I think you are in open a support ticket category.