Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
HenBri
Frequent Visitor

Switch underlying table to a complete report page

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

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

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

2017-08-11_9-17-24.png

 

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

 

2017-08-11_9-25-07.png

 

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:

  • create a query called wktable
  • create a reference to the table wktable and call it goodtable or something similar
  • for the model and hence for all our reports and dashboards we use the table "goodtable" (from a performance point of view this would not work as well in Excel, because there are some issues with caching of the referenced queries)

So we are free to change the source of goodtable to wktable2 or wktable3

 

Hope this gets you started

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

1 REPLY 1
TomMartens
Super User
Super User

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

2017-08-11_9-17-24.png

 

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

 

2017-08-11_9-25-07.png

 

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:

  • create a query called wktable
  • create a reference to the table wktable and call it goodtable or something similar
  • for the model and hence for all our reports and dashboards we use the table "goodtable" (from a performance point of view this would not work as well in Excel, because there are some issues with caching of the referenced queries)

So we are free to change the source of goodtable to wktable2 or wktable3

 

Hope this gets you started

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.