Joining two published Power BI Datasets into one model - is this possible?

[pbi-ai]

I've currently got two reports...Report 1 and Report 2. Each report has it's own dataset, Dataset 1 and Dataset 2.

I've got a requirement to create a report that uses half of Dataset 1 data and half of Dataset 2 data

There is definitely a relationship/JOIN condition between the two datasets, a column called User.

I'm unaware of if it's possible to combine both the published datasets into one big model and create a report off of it. Can anyone point me in the right direction to do this? Is this even possible?

[tackytechtom · Accepted solution]

Hi @pbi-ai ,

I think you should achieve this by using DirectQuery.

Here the initial announcement:

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

Here the official documentation:

Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Docs

Here a tutorial video from guy in a cube:

Blend Power BI datasets with Excel files? INSANE AMAZING! - YouTube

Here a step-by-step tutorial, plus a video:

DirectQuery for Power BI dataset: How does it work? - RADACAD

Let me know if this got you any further 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[pbi-ai]

@tackytechtom thank you for the resources! I think this approach will be my best bet.