Forum Discussion

JP1983's avatar
JP1983
Helper II
3 years ago

create composite model using 2 PBIX file

hi

 

I would like to combine 2 datasets (PBIX ) from Power Bi Service and add the fields from 2 datsets into one visual.Is this possible ?

I am aware that we can create composite model and add 2 PBIX files and create 2 different visuals .But is it possible to create one visual (eg table) and add fields from 2 fields into this table.

 

For example ,Dataset 1 with tables X and Y and Dataset 2 with A and B tables.Please note,X and A have the same structure and Y and B have the same structure.

 

Thanks for your assistance.

Need Help

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    3 years ago

    JP1983 you need to create a composite model and then create a relationship between the tables to visualize the columns from the different tables. Think like you have 4 tables in a single model and how you will set relationship between these tables to use the columns in the same visual, same apply when you create a composite model.

     

     

    ✨ 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!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.