Create report with data from different data sources

[lifesafari]

Hello to everyone 🙂

I need to create a dashboard to display some analys using data from different data sources. 

I have this situazion:
#1 Data Source A -> connect to database

I have create a measure and ned display this on a Card

#2 Data Source B -> Analysis Service

I have create some measure and the display on some Cards


Now i like to create a dashboard to unite report from data source A (#1) and data source B (#2).

How can i do that? I use power bi desktop

Thanks 

[Anonymous · Accepted solution]

Hi @lifesafari ,

You need to create  Dual or Import storage mode in Power BI Desktop, please try to get data from Analysis Service with Import connection type, get data from database with DirectQuery or Import connection type. Then you could create a report with this model.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hey lifesafari,

The options are here, you should be able to join the data sets using the tabs on the left most part of your screen.

[lifesafari]

Hello, sorry..what you means? 

Thanks