Get data from one dataset and applying other data sources

Power BI
1

Hi,

I believe the live connection to a dataset feature while allowing the model to be updated with adtl sources included was made available in the December 2020 release of Power BI Desktop.

I have a published dataset sourced from a spreadsheet file in One Drive.

When I use the Preview Features of “DirectQuery for PBI datasets and AS” in PBI Desktop and then connect to that published Power BI dataset source, I have a live connection to my dataset, but I have no option to add or connect to other sources. All ‘get data’ options are grayed out.

Am I misunderstanding which “type” of datasets allow for them to be used in Power BI Desktop as one of multiple sources, or am I missing a step/action I need to take to allow this to happen?

FYI, I am using the July 2021 version of Power BI Desktop, and my enterprise has Pro licensing.

Thank you,
Kevin

2

Hi @kkieger. IMO, your understanding of composite datasets is correct. I’ve run into this situation as well with one of my clients, and it is their “old” (ancient, actually) database infrastructure that is preventing this from happening. Sounds like your Power BI setup is good, but perhaps the database infrastructure is too old and in need of a newer version to enable this. Not what your wanted to hear, I’m sure, but …
Greg

1 Like
3

Hi Greg,

Thanks for the reply. The live connection to a power bi dataset source works as expected with a dataset sourced from files in a SharePoint folder, but does not allow adtl sources when connecting to a dataset sourced from a OneDrive file.

I’m hoping there’s some explanation for the different behavior.

Kevin

4

Bumping this post for more visibility.

5

HI @kkieger

As @Greg stated it’s really annoying sometime you can’t get it going with composite model. Could you try doing other way, first connect with the 2nd source and then try add the published model to connect. As mentioned earlier, try checking if you can updated your published model.

Can suggest trail and error method only, as this has worked for me when I had similar challenge.

Thanks
Mukesh

6

Hi @kkieger , did the response provided by @MK3010 help you solve your query?

If not, how far did you get and what kind of help you need further?

If yes, kindly mark as solution the answer that solved your query.

7

Hi @kkieger, we’ve noticed that no response has been received from you since August 12. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.