Forum Discussion
Unable to create relationships between tables from SQL Server source
Hello, I have started uisng Power BI Desktop application recently and trying to create some reports using the application. In that process, I am importing some table from 'Get data- SQL Server s...
You need unique values on one side of the relationship. Often, you create a separate query and table with only distinct values and map (relate) everything to that. Power BI is pretty smart about transitive relationships.
smoupre have you seen any benefit of using one query like he has now and referencing it then using M to get distinct values for this table instead of two queries?
kazlik From an evaluation POV it doesn't really make a difference. However, if you reference the query instead of duplilcating it, any changes to the source query will affect the dependents. People often use this to build a report against development server then migrate the source query over to production.
