Semantic Model relationship issue

[Byzza]

Hi All,

I'm currently having issues creating a relationship between 2 Fact tables in a Fabric Semantic Model.

So the steps I've taken

• On my Warehouse --> Reporting --> "New semantic Model"

• Add my 2 tables. A header table and Line Item table.

• create a join per the screenshot below.

• open the semantic model in excel to test.

• Drag the Primary Key from Header to pivot table and filter to single record

• Drag the Lines Number to pivot table

  • all lines in the line table are returned instead of just those linked to single record.

If I create a new Power BI Report and link to these same 2 tables in Direct Query Mode and create the join in Power BI it works fine.

Any thoughts would be greatly appreciated.

[v-prasare]

Hi, May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

If we don’t hear back, we’ll go ahead and close this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum  we’ll be happy to assist.

Thank you for being part of the Microsoft Fabric Community.

[v-prasare]

@Byzza As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

@Byzza As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[Byzza · Accepted solution]

No haven't been able to resolve the issue.  I still haven't only been able to get it working in Power BI and not a MS Fabric Semantic model.  But for now that is ok, and I'm working with this.

Due to limitations on my fabric capacity I was probably going to move this to a Power BI SM in a different Capactiy anyway. 

[v-prasare]

Thanks for the update @Byzza. since you no longer have same query i suggest you to post your comphrehensive solution here and accept it as answer in this way community members with similar queries will find answers easily.

thanks,

Prashanth Are

MS Fabric community support

[v-pbandela-msft]

Hi @Byzza,

Thank you for reaching out in Microsoft Community Forum.

Please follow below steps to resolve Semantic Model relationship issue;

1.Make sure the relationship is set to Many-to-one, active, and with Single cross-filter direction — as shown in your screenshot.

2.The DocEntry values in Production Order Line do not match those in Production Order. This mismatch is why filtering doesn't work in Excel.

3.Excel pivot tables don't fully honor model relationships unless fields are from dimension tables or measures are used.

4.Since the relationship works in Power BI (DirectQuery), use Power BI reports for this scenario to get accurate filter behavior.

Please continue using Microsoft Community Forum.

If this post helps in resolve your issue, kindly consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.

Regards,
Pavan.