Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Combine Two Visual Tables

I've been given a report that contains two tables in Power Bi.  They're identical fields except for one column from a different table.  My task is to combine both visuals into a single visual.  The e...
Need Help
AnkitKukreja's avatar
AnkitKukreja
Super User
4 years ago

Hi! Anonymous 

Appending them would be best in my opinion. Please delete the relationship among these tables and then Append them. As I believe after appending them as a single table you won't need the relationship between them.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello and thank you for the reply! 

    Just to clarify, the two tables don't exist as tables within PowerBi, they're table visualizations created from existing tables.  I've tried creating them as tables and appending them using SUMMARIZETABLES, but it runs my computer out of memory - I'm assuming because of their several relationships.  

    • AnkitKukreja's avatar
      AnkitKukreja
      Super User
      4 years ago

      Hi! Anonymous 

       

      I didn't understand your requirement. What are you trying to achieve?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        I have a Power Bi report that pulls data from Dynamics 365.  It has two almost identical visual tables that the end user wants to combine.  The only difference is a single column, but it comes from a completely different table from Dynamics 365.  

        Making the separate visual tables is simple, but I can't figure out how to combine them into a single visual.