Can you connect to a power BI dataset and another connection?

[Jerush]

Hi All,

I created a dataset on which to build reports. I now need to connect to another datasource and the dataset.  But the options to get data are greyyed out.
Is it possible to connect a Power BI dataset and another datasource in a single report.

Thanks all,
Jerusha

[selimovd · Accepted solution]

Hey @Jerush ,

yes, that's possible with the new "DirectQuery for PBI datasets and AS". It's in preview and you have to activate it first:

Afterwards you can add other data sources to the existing one. Also check out the article as it was announced:

DirectQuery for Power BI datasets and Azure Analysis Services (preview) | Microsoft Power BI-Blog | ...

Or the unplugged video from SQLBI:

Exploring new composite models in Power BI Desktop - Unplugged #1 - YouTube

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Jerush]

Hi @selimovd ,

Thank you so very much for the quick repsonse. I will go through this and the link you sent.

[selimovd]

Hey @Jerush ,

sure, give it a try.

Don't forget to mark it as solution if it worked. Like that, the next user who has a similar issue can see immediately what worked without scrolling through the topic.

If you need any help please let me know.

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Jerush]

Hi Denis,

I tried it and it worked 🙂. Thank you again.