How to connect all visualizations to new table (Prod Table) from existing table (Test Table) ?

[Nagakarthy]

My present visulizations are connected to test table , but now I have to switch all visulizations to Prod table. 

Please suggest me the steps, apppreciate your help on this.

Thanks

[saud968 · Accepted solution]

To switch all your visualizations from the Test Table to the Prod Table in Power BI, you can follow these steps:

Open Power BI Desktop: Launch your Power BI Desktop application and open the report that contains the visualizations connected to the Test Table.

Transform Data:

Go to the Home tab and click on Transform Data to open the Power Query Editor.
In the Power Query Editor, find the Test Table in the Queries pane.
Advanced Editor:

Select the Test Table and click on Advanced Editor in the Home tab.
Copy the M code from the Advanced Editor.
Create New Query for Prod Table:

In the Queries pane, right-click and select New Query > Blank Query.
Open the Advanced Editor for the new query and paste the copied M code.
Modify the source in the M code to point to the Prod Table instead of the Test Table.
Replace References:

Rename the new query to match the name of the Test Table. This will ensure that all visualizations and measures that reference the Test Table will now reference the Prod Table.
Delete or disable the original Test Table query to avoid confusion.
Refresh Data:

Close and apply the changes in the Power Query Editor.
Refresh your data to ensure that all visualizations are now connected to the Prod Table.
By following these steps, you should be able to switch all your visualizations from the Test Table to the Prod Table without having to recreate them

Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!

[Uzi2019 · Accepted solution]

Hi @Nagakarthy 

Try these method I hope this would work for you!

https://www.youtube.com/watch?v=Fd2tU-qull8

https://www.youtube.com/watch?v=XIq5vN5oPf8

https://www.youtube.com/watch?v=E5KngvjPoB4

https://www.youtube.com/shorts/4ePxEd2PMvQ

I hope above videos would help you to solve your query!

[saud968 · Accepted solution]

To switch all your visualizations from the Test Table to the Prod Table in Power BI, you can follow these steps:

Open Power BI Desktop: Launch your Power BI Desktop application and open the report that contains the visualizations connected to the Test Table.

Transform Data:

Go to the Home tab and click on Transform Data to open the Power Query Editor.
In the Power Query Editor, find the Test Table in the Queries pane.
Advanced Editor:

Select the Test Table and click on Advanced Editor in the Home tab.
Copy the M code from the Advanced Editor.
Create New Query for Prod Table:

In the Queries pane, right-click and select New Query > Blank Query.
Open the Advanced Editor for the new query and paste the copied M code.
Modify the source in the M code to point to the Prod Table instead of the Test Table.
Replace References:

Rename the new query to match the name of the Test Table. This will ensure that all visualizations and measures that reference the Test Table will now reference the Prod Table.
Delete or disable the original Test Table query to avoid confusion.
Refresh Data:

Close and apply the changes in the Power Query Editor.
Refresh your data to ensure that all visualizations are now connected to the Prod Table.
By following these steps, you should be able to switch all your visualizations from the Test Table to the Prod Table without having to recreate them

Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!

[Nagakarthy]

Thank you so much for your help, your solution worked.