Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Hi @Tahreem24
Hi @Tahreem24
Connect to data from SQL Server with Power BI, Then create relationship for these tables in Power BI.
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
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!
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.
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.
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://code.tutsplus.com/articles/sql-for-beginners-part-3-database-relationships--net-8561
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |