cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kstrom New Member
New Member

multiple data sources not related

I am new to PowerBI and I'm not finding any forums discussing my issue. My manager wants a dashboard of unrelated items on a single dashboard. The data comes from Excel spreadsheets and some from SQLServer. But the individual charts and information should not be connected. Is that possible?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: multiple data sources not related

@kstrom There are multiple ways to do this, but here is a high level implementation that would work.

Create a seperate Desktop file for each report (connection / reports) in Power BI Desktop

For this example say you have 3 sources. You build 3 files named 1,2,3 with different reports.

You publish these files to app.powerbi.com

You will then have dataset 1,2,3 and reports 1,2,3

You can than take a visual, or visuals, from each of these reports and "Pin" them to the same dashboard.

As the manager clicks on each dashboard "Tile" they will be taken to each of the reports where the visuals came from.

 

 

Alternatively, you could build this all in one PBIX (Desktop file) and just work of different elements. Your model doesn't need to be all connected behind the scenes, but this might be confusing if any end user needed to use it.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

1 REPLY 1
Super User
Super User

Re: multiple data sources not related

@kstrom There are multiple ways to do this, but here is a high level implementation that would work.

Create a seperate Desktop file for each report (connection / reports) in Power BI Desktop

For this example say you have 3 sources. You build 3 files named 1,2,3 with different reports.

You publish these files to app.powerbi.com

You will then have dataset 1,2,3 and reports 1,2,3

You can than take a visual, or visuals, from each of these reports and "Pin" them to the same dashboard.

As the manager clicks on each dashboard "Tile" they will be taken to each of the reports where the visuals came from.

 

 

Alternatively, you could build this all in one PBIX (Desktop file) and just work of different elements. Your model doesn't need to be all connected behind the scenes, but this might be confusing if any end user needed to use it.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)