Is there posibility to make report that will work on 2 DBs with same structure but diffrent records?

[Xax]

Hi,

I'm wonderind is in Power BI posibility to make report on one DB and after that send file with report to someone else, who has DB with same structure (same tabels, colums, etc) and diffrent records in it. So he could see how this report looks with his set of data in his wersion on DB.

[PaulDBrown]

Have you tried saving the file as a Template? Just an idea; I’ve never tried myself...

[Xax]

Thanks for help. It works I think, but it is not all I need.

Is it posibility to choose from which DB You want to import data at start?

When I open new report I can import data from DB to make report I have to choose my DB. But this choice is remembered and I can't change it in easy way. I can change it manyally in query editor for each table, but what if I have 100 or more tables? I don't want to waste much time every time I need to use this report on different DB.

Is it one simple way to do it?

[Xax · Accepted solution]

I found a solution,

You can go to Query Editor. Click on Manage Parameters in it. Type Your DB (it is temporary), and use this parameter instead of text value, every time You load new table from DB. After that, when You save it as template, and import, new window will appear with fild in it that You can use to type DB in it. And it works on every DB with this parameter.