Forum Discussion
See all rows in tabel visualisation
Hi all, I am trying to combine 2 tables into 1 from 2 different sources. When I made the relationship and try to use the table visualisation, not all the IDs is being displayed, is there any way...
Anonymous - Well, it really shouldn't matter which one you choose. Keep the bridge table column and try changing those relationships to single direction versus Both.
Hi Greg_Deckler
I tried to create your bridge table in Power Query. Reference your original queries and create 2 new queries that only have that column in them. Use an Append query to union them. Then do a Remove duplicates operation.
And it works! However, I get the errror message below and I cant seem to show the data.
Greg_Deckler
Community Champion
Community ChampionAnonymous - Hooray! Task 1 accomplished, get an appropriate bridge table. Where are you getting that error? When you refresh or ?