Forum Discussion

Jeanxyz's avatar
Jeanxyz
Power Participant
3 years ago
Solved

create a composite data model using two power bi datasets

I want to create a composite data model using data sources from two power bi datasets. I have created the two datasets by publishing two power bi reports.  I then followed the steps in the video be...
  • parry2k's avatar
    3 years ago

    Jeanxyz here are the steps:

     

    - new pbix file, connect to a power bi dataset

    - now added another power bi data and it will come with the following warning message

    - select add a local model 

     

     you will get a table selection menu and you should be good to go. 

     

     

    Also make sure you are using the most recent Power BI (April, 2023) and prior to it you have to turn this feature on in the preview.

     

    Follow us on LinkedIn and  to our YouTube channel

    I would  Kudos if my solution helped. If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!