Duplicate view for different data sources in one pbix file

[luke050]

Hi

Problem: I have several sqlite3 database files, the file structure is identical on each

I have created a dashboard that visualizes the data from this database (one at a time) I have some custom measures there.

Currently when I want to display a visualization for another source I need to open my dashboard then  Transform data > Data source settings and i can change source db

the problem is i have to do this every time i change source

For example, I would like to have 5 sources loaded at the same time and copy this dashboard for other sources.

assuming this is my original database:

I added the other 4:

the problem is that now for each view I have to change the values ​​of the fields which currently have 'sessions' to display data from 'sessions (2)', 'sessions (3)' etc. and there is a lot of it.

Creating several pbix files is not a solution since I want to have these data for comparison in one file

[luke050]

maybe I wrote it wrong, but the methods given above will still display one source at a time:

my goal is to have same report several times for multiple sources at the same time:

as I wrote, in my case the sources are  sqlite3 databases which specified by ODBC.

in this screenshot above, both views display the ACC1 source and I would like the other one to display the ACC2 source at the same time

[parry2k]

@luke050 you should append data from all these sources as one table which you can do in PQ, and add like a column from "Source", and once it is done, now you can slice the data by source using filter or slicer. This is the way to approach it.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[amitchandak]

@luke050 , refer if this can help

https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters