Forum Discussion
Define relationships in MySQL source
I am working on getting a MySQL source available to a lot of managers to be used in Power BI. I have everything working nicely but I would really like is to be able to predefine all relationships so ...
Hi jeroenbenda,
Currently the unique id for every table is called id and reference to another table will be something like billid. Is it possible for me to add data somehow on the source that if people load the data source in BI that all relationships are defined.
Based on my test, when importing data from MySQL database on Power BI Desktop, if we have "Include Relationship columns" option checked like below, and make sure the tables are related by Foreign Keys(id and billid) in MySQL databases, all the relationships will remain among the imported tables on Power BI Desktop.:smileyhappy:
Regards
Thank you. That does work indeed. Only thing left is preventing all tables to be linked because the all share the same key, namely id as the unique key. Is there any way to do that?