Best practices for connecting multiple data sources

[ronaldbalza2023]

Hi everyone, just wanted to have tips, tricks, or some of the best practices when connecting multiple data sources in one dashboard. Data sources will be coming from SSAS (will be coming from a third-party company), on-prem SQL databases, and excel. Thanks in advance 🙂

[v-zhangti · Accepted solution]

Hi, @ronaldbalza2023 

The visualizations on a dashboard come from reports and each report is based on one dataset. In fact, one way to think of a dashboard is as an entryway into the underlying reports and datasets. Selecting a visualization takes you to the report that was used to create it.

The visualizations on a dashboard may come from one underlying dataset or many, and from one underlying report or many. A dashboard can combine on-premises and cloud data, providing a consolidated view regardless of where the data lives.

You can connect to the data sources separately, make a report and upload it to Service, and tile the view to a dashboard on the same page.

If you want to merge more than one data source to create a report, you can use the on-premises data gateway to merge or append on-premises and cloud data sources in the same query. 

This is the relevant document, hope to help you:

https://docs.microsoft.com/power-bi/connect-data/service-gateway-mashup-on-premises-cloud 

https://docs.microsoft.com/power-bi/consumer/end-user-tiles 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ALLUREAN]

Hi, @ronaldbalza2023 

You can use dataflows to organize your sources in one workspace. The refresh time is fast when you have all dataflows already updated.