Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
Is there any way to just change the specific underlying table to a report page or visualization on a report page?
Assume you have built a page which consists of a great number of fields from "Table x". After that, you have duplicated that table (named "Table y") and it will thus have ALL the existing fields available as the old, original, one. I want to be able to just "switch" in the report or visualization on a report page from Table x to Table y WITHOUT having to drag&drop all fields one-by-one.
Any efficient move to make? 🙂
Br/Henrik
Solved! Go to Solution.
Hey,
maybe this would work also in your case ...
I sometimes work against a database schema that evolves. I started working against a table called smallertable
Than on notice of the team I swith the underlying table in the QueryEditor: from smallertable to smalltable just by editing the string in the navigation step
For me this works great ...
So maybe you should not looking to change the link from the visual to its underlying tabel, but to change the content of the used table editing the source.
For this reason we often use this approach:
So we are free to change the source of goodtable to wktable2 or wktable3
Hope this gets you started
Hey,
maybe this would work also in your case ...
I sometimes work against a database schema that evolves. I started working against a table called smallertable
Than on notice of the team I swith the underlying table in the QueryEditor: from smallertable to smalltable just by editing the string in the navigation step
For me this works great ...
So maybe you should not looking to change the link from the visual to its underlying tabel, but to change the content of the used table editing the source.
For this reason we often use this approach:
So we are free to change the source of goodtable to wktable2 or wktable3
Hope this gets you started
User | Count |
---|---|
127 | |
72 | |
70 | |
58 | |
53 |
User | Count |
---|---|
192 | |
96 | |
67 | |
64 | |
54 |