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.

KNP's avatar
KNP
Super User
4 years ago

If you could share your code from Power Query (Advanced Editor) that would be helpful in diagnosing your issue.

Be sure to mask any sensitive info.

I'm specifically looking for which columns you selected to merge (join) on.

 

What happens if you select the split arrows at the top of one of those columns with all the tables and choose expand to new rows?

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for taking the time to reply KNP, and sorry for my late reply too.

v-jingzhang's recent reply above seems to solve my problem.

Related content