Forum Discussion
Solved
Bridge Table
I am trying to create a Bridge table with multiple unqiue columns but I am having difficulty, I have resulted to creating 4 indivual bridge tables. I first tried to create the Bridge table by app...
Hi Earosenfeld ,
these are not bridge tables but dimension tables and therefore completely correct.
The question is, are there any master data tables in your system from which you can load the unique values for your dimension table?
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
Hi Earosenfeld
Check the solution suggested by mwegener, select two columns and remove duplicates.
If problem still occurs, please share more details here, including why you need to create the bridge tables.
In Addition, you could refer to the following:
Create and manage relationships in Power BI Desktop
Bridging Table - Relationships
Best Regards
Maggie
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.