Forum Discussion
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?
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.
1 Reply
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.