Forum Discussion
Not displaying data in a table visual while connecting with Bridge Table.
Dear Team,
Problem- Not diplaying fileds from two different table if it is connected with bridge Tabel.
Description:- I have two table in my model "Seg Leders" and "Main Sheet". and i have created a bridge table of a common filed from both "Project Code" using Power Query.
Relation- One(Bridge Table) to Many(Seg Leaders)
One(Bridge Table) to Many(Main Sheet).
when i pull the data from Bridge table and from other two table into a table visual, shows me an error"can't determine the relationship"
Please help me out of this situaltion.
5 Replies
Hi NiteshkrNishant
when you click on see details what happens?
can you confirm that the key columns are same data type and have no discrepancies such as trailing spaces or different formats in the column name?Everthing seems correct(Data Type, Relationship ).
I am attaching some pics for your refrence.
did you check if there are any invisible spaces in the column name? or can you upload a demo data file?
I have prepared a sample data. but i am not able to attach my excel demo sheet here. could you please guide me on the same?
try using file.io and share the link here.
