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

     

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!