Dimension Table Relationship

[nchamilton162]

Good morning,
I am attempting to connect a table to my existing simple model. Using the model below. I can create a table visual and add elements from the Project Table and Procedure Table, but when I try to pull elements from the Procedure Workflow history table I get the "Can't determin relationships between the fields error" if I have any project elements in my table visual. I assume it's because I don't have a connection between the workflow history table and the Object relationship table but in other analytics tools, this wouldn't be an issue. I have confirmed data types and that I'm using the appropriate pk. Can someone please tell me what I'm doing wrong and how to correct this issue without adding a measure to my table? If I connect the Procedure Workflow History to the Object Relationships table then I end up with a many to many which I'm trying to avoid.
Thanks,

Nick

[MFelix]

Hi @nchamilton162 ,

To what I can see from the image you shared the fact that you are using bidirectional filters on your model is for sure part of the reason of the errors you are getting, because all tables are being filter by all tables.

Power BI works better with star schemas and the bidirectionality if needed can be recreated using measures, because the vertipac engine will be much more effective in that manner.

However only looking at the image of your relationships does not allow to give an effective answer and what is happening, and this may be due to different options.

I also have a question on why you refer that you don't want to add a measure to your table, you can use measure has a filter on your visualizations and they will impact the visual without the user be aware of their presence.

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

[rajendraongole1]

Hi @nchamilton162 -If the Procedure Workflow History table has a column that matches a column in either the Object Relationship table or the Project Table, use that column to create a bridge.
The bridge table could include unique IDs or a combination of keys that link Procedure Workflow History to the existing schema.Connect the Procedure Workflow History table to the bridge table with a one-to-many relationship.
If necessary, connect the bridge table to the Object Relationship table or Project Table.
Ensure fields from Procedure Workflow History flow correctly via the bridge to interact with elements in your model.

I hope creating bridge table works in your scenerio . please check