Join in SQL server

[Tahreem24]

HI Power BI Community,

I have 3 tables lets say Table A, B,  and C from SQL Server. Table C contain key column only which joins table A and B.

Basically table relationship is as given below:

Table A to C --> Many-1  and Table C to B --> 1-Many.

Now, my query is how to validate my above data from SQL server backend. Which type of join should I use to validate my power bi report.

[v-juanli-msft]

Hi @Tahreem24 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

Best Regards

Maggie

[v-juanli-msft]

Hi @Tahreem24 

Connect to data from SQL Server with Power BI, Then create relationship for these tables in Power BI.

https://www.red-gate.com/simple-talk/sql/bi/power-bi-introduction-working-with-sql-server-data-in-po...

https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tahreem24]

Hi @v-juanli-msft,

I have already created relationship between those 2 tables. My query is how to cross check my power bi data with SQL Server data.

Thanks!

[v-juanli-msft]

Hi @Tahreem24 

Sorry, I'm not clear about your requirement.

Data in Power BI can't return back to data source.

In Direct query mode, Power BI can send queries back to SQL Server to request data from SQL Server to Power BI.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tahreem24]

Hi @v-juanli-msft ,

I have ingested data from SQL server to Power bi and have created relationship between those table in power bi. Now I want to validate my report with my SQL server for testing/QA purpose. 

So, I want to know which type of join should I use in SQL server for testing purpose for one-many relationship in power bi?

Thanks.

[v-juanli-msft]

Hi @Tahreem24 

You could refer to these articles:

https://www.tech-recipes.com/rx/56738/one-to-one-one-to-many-table-relationships-in-sql-server/

https://www.quackit.com/sql_server/sql_server_2017/tutorial/create_a_relationship_in_sql_server_2017...

https://code.tutsplus.com/articles/sql-for-beginners-part-3-database-relationships--net-8561

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.