Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Assuming I have to change the name of a Query because the Excel Sheet name has changed, do I have to manually adjust all measures on my own or is there any function which I can use to automatically perform this change?
Example: Current Query name is "2023Test" with measure:
Test = SUM('2023Test' [Sales])
Now the excel sheet name changes from "2023Test" to "2023Final"
Do I have to adjust all measures referring to '2023Test' manually to '2023Final'?
Thanks in advance and best regards!
Solved! Go to Solution.
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
In this case you do not need to do anything, all the measures will be updated automatically with new query/table name.
Thanks,
Arul
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]
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
Thanks a lot! That solved the issue and helped!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |