cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
luke050
Frequent Visitor

Duplicate view for different data sources in one pbix file

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

Bez tytułu.png

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:

Bez tytułu1.png

I added the other 4:

222.png

 

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

3 REPLIES 3
luke050
Frequent Visitor

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.

pbix2.png

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

 

pbix3.png

parry2k
Super User III
Super User III

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






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





amitchandak
Super User IV
Super User IV

@luke050 , refer if this can help

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.