Connecting to Multiple datasets

[Anonymous]

Hi All,

Could anyone please give some idea how can we query on a datamodel inside power bi externally ?

We have a requirement to query multiple datasets and get the value from each one of them. Is there any optimal way of doing this ?

My requirement is to connect to multiple datasets (> 10) and create a combined report using the metrics from each dataset. Atleast if , i can query on those datasets to get the metric value to a text file which then i can read into my combined report is also useful.

I'm ok if there are multiple steps/tools needed to achieve this. but trying to avoid 'Importing each dataset'.

[v-chuncz-msft]

@Anonymous 

You may check the post below.

https://community.powerbi.com/t5/Desktop/Power-BI-Service-only-one-dataset/m-p/396335#M180835