How to join views in power bi

[Anonymous]

Hello. On SQL Server I have created views, within which there are both values and aggregate measures of columns from the same or different tables, which I then imported into Power BI. Now, however, I want to make the data from the different views communicate with each other.
How do I do this? Do I need to link and join the views together? I don't have a unique key in the views. Thank you!

[Anonymous]

Yes, but how i connect the views? i have to add a primary key and foreign key in each table? thank you!

[lbendlin · Accepted solution]

forget the term "views".  Everything in Power Query is a "query"  that is then represented as a partition to Power BI which treats each query as a separate "table". Power BI doesn't care what the table source is.

You can merge queries on more than one key in Power Query (and even on custom logic).  But - whenever you merge queries in Power Query a little kitten dies.

You can join tables in Power BI based on a single key only.  If you need multiple join fields then create composite keys.

[lbendlin]

You create a data model in Power BI, ideally a star schema.  But if your data doesn't support that then you have to apply other relationships and join directions.  The data model needs to follow the business scenario.