Forum Discussion

Variation_31415's avatar
Variation_31415
Regular Visitor
3 years ago
Solved

Change in Query name

Hello!   I am currently working on a report where I have created a few pages with several measures. All of these measures are linked to different Queries. Now my question is the following:   Assu...
Need Help
  • Arul's avatar
    Arul
    3 years ago

    Variation_31415 ,

    In the applied steps on the right side, got to navigation step then expand the formula after selecting navigation. Next replace "2023Test" with"2023Final" in the formula bar and then click apply.

    Thanks,

    Arul

     

Arul's avatar
Arul
Super User
3 years ago

Variation_31415 ,

In this case you do not need to do anything, all the measures will be updated automatically with new query/table name.

Thanks,

Arul

Variation_31415's avatar
Variation_31415
Regular Visitor
3 years ago

Dear Arul,

 

thank you very much. However, I have tried this (opened excel, changed name, saved it and refreshed the data). I do get the following error in the Powe Query Editor:

 

Expression.Error: The key didn't match any rows in the table.
Details:
Key=
Item=2023Test
Kind=Sheet
Table=[Table]

  • Arul's avatar
    Arul
    Super User
    3 years ago

    Variation_31415 ,

    In the applied steps on the right side, got to navigation step then expand the formula after selecting navigation. Next replace "2023Test" with"2023Final" in the formula bar and then click apply.

    Thanks,

    Arul

     

    • Variation_31415's avatar
      Variation_31415
      Regular Visitor
      3 years ago

      Thanks a lot! That solved the issue and helped!