Gerhard Brueckl on 14 Feb 2015 01:00:15
If multiple tables are imported from SQL Server and relationships exist between those tables (in the database) the very same relationships also get created when you import those tables into Power BI.
For OData feeds you can also specify tables and relationships but the relationships are then not created automatically within Power BI. As OData becomes more and more important this would help a lot and bring more services to export their data as OData feed to allow reporting in Power BI.
- Comments (2)
RE: Retrieve Relationships from OData feeds
Being able to infer relationships from _derived_ entities would also help in this respect. posted in a Wish List item on this as well.
RE: Retrieve Relationships from OData feeds
We are leveraging a graph database and the underlying relationships are not a great fit for foreign key relationships. It would be ideal if Power BI supported the relationships exposed by the OData feeds directly.