Pull form different data sources?

[OneWithQuestion]

I have 10 different data sources with multiple PBI files in the service connected to each.

Is there anyway to mix data sources so I can build a summary/overview dashboard on all 10?  (Then I'd use bookmarks and hyperlinks to let users click to go to each individual PBI report).

One data sources is in Azure SSAS and is Sales, another is in a PBIX file and tracks HR metrics.  I want a consolidated view over all 10 so I can pull widgets in from each.

[v-jingzhang]

Hi @OneWithQuestion 

I agree that Power BI Dashboard would be the simplest method to meet your need. It seems you only want to show 13 separate measure values in the same page. So you can put each of them in a card visual in their corresponding reports and set up conditional formatting there. Then you can pin these visuals from different reports to the same dashboard as tiles. By clicking on a tile, you can go to the specific report it comes from. 

You will find more how-to guides from the following links:

Intro to dashboards for Power BI designers

Create a Power BI dashboard from a report

Tips for designing a great Power BI dashboard

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[PaulDBrown]

It sounds like you need to build Dashboards, which can contain visuals from different reports.

https://docs.microsoft.com/en-gb/power-bi/consumer/end-user-dashboards 

[OneWithQuestion]

Normally yes, absolutely.

What I was hoping to do was pull together measures from several different data models and dispaly them as KPIs on a single visual.

So they could see 10 of the 13 KPIs were green and 3 were yellow/red.

Then they could click a hyperlink next to the 3 and go to the PBI reports/dashboards/etc for that specific KPI and datasource.

[PaulDBrown]

Won't a dashboard work? If you add visuals from different reports and you click on any, the corresponding report opens up