Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Publishing deleted connections between tables?

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?

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      Anonymous
      Not applicable