Publishing deleted connections between tables?

[Anonymous]

I have two tables - Activity and BusinessCase
The tables are currently linked (Cardinality Many to 1) Cross filter direction Both
I have a formula that calculates
DIVIDE (CALCULATE (
COUNT(Activity[id]),
ALL(BusinessCase[Status], L0_Raynet_BusinessCase[Group])),
COUNT(BusinessCase[id])
,
0
)
The formula works for me. At the same time I have filters from BusinessCase (Type of service, Status, Owner of businessCase) in the desktop version. All filters work for me (Individual activities are linked and assigned to the groups I filter). The problem occurs when I publish the version to the online environment. For example, the moment I filter Type of service, I get a count of 0 activities (all are blank). When publishing PowerBi, is there any transformation taking place where the connection between the tables is modified?

[v-xiaoyan-msft]

Hi @Anonymous ,

”When publishing PowerBi, is there any transformation taking place where the connection between the tables is modified?“
I don't think there is such a design in Power BI.

Can you show me a screenshot of your model view (the page with the table relationships), and please be careful to hide the key sensitive information.

Best Regards,
Community Support Team _ Caitlyn

[Anonymous]