cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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.

Near SE WI? Join our PUG Milwaukee Brew City PUG
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.

Near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 83 members 1,492 guests
Please welcome our newest community members: