Forum Discussion
Merging tables from a database - Difference between "Value" and "Table"?
Hi Anonymous
When you connect to the database at the first time, expand Advanced options and uncheck Include relationship columns option. By default, this option is checked and it will import linked tables into Power BI. That's probably why you see so many unexpcted linked tables.
For Merge Queries tutorials, you could refer to below links:
Merge queries overview | Microsoft Docs
Append vs. Merge in Power BI and Power Query - RADACAD
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Thanks for your swift reply!
I already had this option ticked/activated.
So it seems that it's an all or nothing situation (whether have all the relationships even unwanted ones or no relationships at all).
The advanced option "Include relationship columns" from the connexion pane seems to overwrite the "Import relationships from data source on first load" from the options pane.
If there is something I am missing here, I am still interested in knowing the solution.
If this is indeed how PowerBI works, it may need to be improved.
Thanks anyway for your support!
If I am missing someting
Hi Anonymous
I didn't notice this before. Do the tables you want to import have relationships (foreign keys) between each other directly, not through other unimported tables?
Jing
Yes, they all have relationships between each other directly!