Forum Discussion

tmhalila's avatar
tmhalila
Resolver II
4 years ago

Update Power BI Model from the SQL Server

Hello, Assist please, I am importing data from the SQL Server database, while the ETL team is in the progress of updating tables in the Database. From the Power BI desktop, I disabled the Autodetect...
Help
Hariharan_R's avatar
Hariharan_R
Solution Sage
4 years ago

Hi tmhalila 

Relationship within Power BI will be based on the name of the columns across tables and data type. if you have product key in both product and product category table then relationship will be created automatically if those check boxes are enables. If not then we need to manually create a relationship between the tables.

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin


tmhalila's avatar
tmhalila
Resolver II
4 years ago

Sorry if I am not getting to you quickly.
From my scenario, I have unchecked the two boxes in the relationship part but once I select the "Select related Table" button then the new table creates a relationship with the available tables.

Now, my question is the relation created automatically by Power BI? or is the one coming from Database Server ..... NOTE I am importing data from the SQL Server and I need the relationship from the Server not manually created in Power BI.