Forum Discussion

bdehning's avatar
bdehning
Post Prodigy
3 years ago

Copy Query Table Column data from one Table to another

I added a new Query Table into Power BI but I need to insert a new column into that table from another query table.    How do I accomplish that? 
Need Help
Arul's avatar
Arul
Super User
3 years ago

bdehning ,

Do you have any common column between these two tables?

Thanks,

bdehning's avatar
bdehning
Post Prodigy
3 years ago

Actually I do have one.  Number of rows are different and why I want to move data from one to the other and thenremove the outdated Query

  • Arul's avatar
    Arul
    Super User
    3 years ago

    bdehning ,

    Could you provide the clear explanation and the expected output?

    Thanks,

    • bdehning's avatar
      bdehning
      Post Prodigy
      3 years ago

      Well I was using a desktop table with two columns and I would occasionaly add rows to the table when made aware of additions by another department.   

       

      I found the main column is kept on a server and is updated, but I would need to add the data for the second column rows which could be added on desktop.      

       

      I want to connect to Server Table column with desktop Power BI and have the the other column that I could fil out and update when new server rows are added.