Forum Discussion
Need to replicate the table with the same schema for a different data account
Hello Power BI community,
I have two data with the same schema stored in AWS RDS. They are actually for our account_1 and account_2 of our company and have been extracted from the same API so the schema is the same. Now I charged Account_1 DB to GDP and worked on it and completed the panel and now, I want to replicate the same panel in account_2.
What is the quick and easy way to replicate this work?
I've created several tables, columns, and measures to Account_1 dashboard and it would be better if I can somehow replace the database to Account_2 and have the same dashboard ready to Account_2 as well.
Any suggestions will be helpful.
better
Vatsal Raval
5 Replies
- Greg_Deckler
Community Champion
Yes, go to the Advanced Editor and edit the Source line.Greg_Deckler I tried that initially. So it is an SQL connection from AWS. So I have the same endpoint for both of them but different DB names. I tried changing the DB name because that is the only variable and It gave me an error like "The key didn't match any rows in the table."
- Greg_Deckler
Hmm, that's odd. You may also need to edit the Navigation step. Generally the way I troubleshoot is to create two queries that work. Then I go and replace one with the other in terms of lines until things work. It's really difficult to troubleshoot these kinds of things virtually but if you are in Advanced Editor you are halfway there.
