Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Merging tables from a database - Difference between "Value" and "Table"?

Good Morning, Afternoon, Evening, fellow PBI users,   I want to merge several tables from our company database, to recreate a view (or snapshot) from our ERP platform.  This snapshot has columns f...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    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.

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Yes, they all have relationships between each other directly!

Related content