Best practices for connecting multiple data sources

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.