Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
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
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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.