Forum Discussion

tmendoza's avatar
tmendoza
Icon for Resolver I rankResolver I
5 years ago

Bi Directional Cross filtering breaking when server refreshes

I've got a visual that ends up having a faulty relationship after a server refresh. When I pull it into the power bi desktop app, the visual appears to fix itself and the relationship is fixed, so t...
Help me please
FarhanAhmed's avatar
FarhanAhmed
Icon for Community Champion rankCommunity Champion
5 years ago

Have you tried to refresh the data at desktop? Is it refreshing fine?

Is it possible for you to share the screenshot of the Error & Data Model?

tmendoza's avatar
tmendoza
Icon for Resolver I rankResolver I
5 years ago

Hello FarhanAhmed,

Yes, the refresh on the desktop is working fine.

This is what the visual looks like unfiltered. I've got the axis showing the data in terms of division. To the right is the division Page level filter.

 

This is what it looks like on a good refresh (desktop app). Page level filter is selecting the West and the visual shows the west division.

Works in Desktop App

This is what it looks like after published and a server refresh with the same Division filter selected.

Does not work when server refreshes

I've tested this on the PBI service too and it goes screwy after a refresh as well.

But works like a charm on the desktop app.

  • FarhanAhmed's avatar
    FarhanAhmed
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Looks weird, is it possible to share the screenshot of the model?

    What relationship are you using in the model?

    Page Level Filters & Visual are using the same column from the same table? right ?

    • tmendoza's avatar
      tmendoza
      Icon for Resolver I rankResolver I
      5 years ago

      FarhanAhmed 

      Thanks for responding.

       

      Attached is a screenshot of another page in the same dashboard. Same concept, this visual is more simple though.

       

      I'm using a many to one relationship with cross filter in both directions.

       

      The page level filter and visual are not using the same column, Division (page level filter) comes from the origianl table and the divisions shown in the visual are values in the reference table. the reference table is joined to the original via a index. 

      Once again, this has no problem working on the power bi app, but fails after a refresh in the server. It seems that the server is missing some sort of logic that the power bi app has. When it breaks after a server refresh, I pull it into the app and it littereally fixes itself.

      The method I used to create this relationship can be seen by this guy in a cube video: 

      https://www.youtube.com/watch?v=n-OWNaCUU0o

      • FarhanAhmed's avatar
        FarhanAhmed
        Icon for Community Champion rankCommunity Champion
        5 years ago

        looks like Cross Filter Direction is causing issues in Power BI Web.

         

        One more thing that you can do is to delete the dataset in Power BI Web and then republish the report in the server.