Bi Directional Cross filtering breaking when server refreshes

Question

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 the problem only happens when the server model is refreshed.

The visual is using bi directional cross filtering and it works like a charm on the desktop app and works when published to the server up until the server refreshes.

Has any one experienced this issue or does anyone have any suggestions on how to resolve it.

Thanks in advance,

Tom

greg_deckler · Answer

tmendoza&nbsp;What visuals are we talking about here? Is one of them a third-party visual?
You could check the Issues forum here:https://community.powerbi.com/t5/Issues/idb-p/IssuesAnd if it is not there, then you could post it.If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

tmendoza · Answer

Hello&nbsp;Greg_Deckler,The visual is the basic clustered column chart that comes with PBI.Works fine in the desktop app, but when published, it does not respond well to a server refresh.

farhanahmed · Answer

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 &amp; Data Model?

tmendoza · Answer

Hello&nbsp;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.&nbsp;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 AppThis is what it looks like after published and a server refresh with the same Division filter selected.Does not work when server refreshesI'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 · Answer

Looks weird, is it possible to share the screenshot of the model?What relationship are you using in the model?Page Level Filters &amp; Visual are using the same column from the same table? right ?

Forum Discussion

Bi Directional Cross filtering breaking when server refreshes

8 Replies

Related content

Bi-Directional filtering

Refresh Direct Query not refreshing

DrillThrough filter direction

bi-directional cross filter

Direct query connection not working in Incremental refresh