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'.