Forum Discussion
Creating a unique table with 2 columns which is pulled from multiple tables in the report
You can duplicate each of the fact tables and then remove all columns apart from ID and Name.
Append the tables together.
Then select ID and Name in the Appended table result, and Remove Duplicates
First of all make a copy of all the tabels in power query using duplicate. From each table select Client ID and Client Name column and remove other columns. And then use append query to merge all into one table and name this table as Client List. Close and Load power query.
First of all make a copy of all the tabels in power query using duplicate. From each table select Client ID and Client Name column and remove other columns. And then use append query to merge all into one table and name this table as Client List. Close and Load power query.
Thanks NishPate for your response. After duplicating and appending, can i remove the duplicated tables? will it impact the appended table?
Hi, You cannot delete them as if there will be a new data than the newly created table will fail. Instead you can uncheck the "Enable Load" option in power query by right clicking on those tables and those tables will not show up in your report pane.