Forum Discussion

ironryan77's avatar
ironryan77
Icon for Kudo Commander rankKudo Commander
9 years ago
Solved

How to select related tables?

Does this functionality work?  I have tried using Select Related Tables when getting data from SQL Server and OLE DB, but each time I select this option, it says: We didn't find any more related tab...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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.

Datatouille's avatar
Datatouille
Icon for Solution Sage rankSolution Sage
9 years ago

Yes RelatedTable function works for me.

Obivously, you need a relationship between your 2 tables.

RelatedTable goes from the One side to the Many side.

 

What is not working for you ?

ironryan77's avatar
ironryan77
Icon for Kudo Commander rankKudo Commander
9 years ago

Oh, so it sounds like I need to define relationships before I can select related tables?  I don't have any relationships defined in Power BI yet for these tables.  But many other tables are sourced from this one SQL table that I chose "Select Related Tables" on.  If I need to define relationships first, then what is the benefit of this feature?