Need to replicate the table with the same schema for a different data account

[Anonymous]

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

[Greg_Deckler]

Yes, go to the Advanced Editor and edit the Source line.

[Anonymous]

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

[Anonymous]

@Greg_Deckler So I want to make one thing clear that, the only schema is same not the values. Probably that is the error "The key didn't match any rows in the table." 

[Greg_Deckler]

Where are you getting that error? In the Query Editor, when you refresh data?