Forum Discussion
Multiple Bridge Table Error
Why cant I show data in a table visual using multiple tables connected to a bridge table?
So what I would like to happen is show columns in a table visual coming from different columns/tables connected to a bridge table. How is that doable?
Table connection: All mapped from Bridge Table using ID with One to Many Relationship on the other 3 tables.
Bridge Table: HR___HR_HR
In the table visual I have selected two fields to show 1. ID - which is coming from HR___HR_HR and 2. APPLICATION_NAME coming from ARC Application_Access which is all good (see pic below):
The problem comes when I add a thrid column coming from the other tables ex. HR___HR_AD and HR___HR_RACF. On the pic below, I try to add the "adid" column from HR___HR_AD but it is not showing an error in the table. How can I fix this making it show in the table with the other columns?
3 Replies
Hey,
what you are aksing for is not doable without creating measures or adjusting your model.
If you want to combine columns from different tables in a table visual, these tables have to be
- adjaccent, meaning directly related or
- indirectly connected by a "bridge" table where each table is one the one side and the "bridge" table is on the many side, but using the term "Bridge" table in this context is misleading
Maybe this blog post of mine gets you started:
https://www.minceddata.info/2018/03/16/to-treatsas-or-not-to/
Hopefully this gives you an idea
Regards
Tom
Can you give me the measure or calculation in order to achieve this? I would really appreciate it. Thanks
Hey,
please share a pbix file containing sample data, but all relevant tables and proper relationships. Upload the pbix file and share the link.
Please provide more details about the Business Problem that you want to tackle with your solution.
Regards
Tom
