Forum Discussion
Kudo CommanderHow to select related tables?
Yes, you have to create the relationships in the Power BI model even if corresponding relationships already exist in the source database. Power BI can automatically create relationships when you load two tables with matching key columns in a 1:M pattern, but I don't like to rely on that. Just manually set them up in the relationship manager.
Yes, you have to create the relationships in the Power BI model even if corresponding relationships already exist in the source database. Power BI can automatically create relationships when you load two tables with matching key columns in a 1:M pattern, but I don't like to rely on that. Just manually set them up in the relationship manager.
I dont understand how this feature is supposed to work. Let say I am starting a new BI project, I have all my data in SQL Server, with all the tables nicely organized with PK and FK.
If I select my fact table and click on the select related tables button, it does not find any. The answer above says that the relationship must already exist in PowerBI, but I am starting my project, getting the data is the first think I am suppoesd to do. Am I missing something?