Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to 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.
Yes, but how i connect the views? i have to add a primary key and foreign key in each table? thank you!
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.
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.
User | Count |
---|---|
77 | |
75 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |