Forum Discussion
Bi Directional Cross filtering breaking when server refreshes
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:
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.
When you say Power BI Web, are you talking about the On Prem Server?
It certainly is causing an issue in the Power BI Report server. Is this a bug that Microsft needs to work out?
I feel like the Desktop app should behave the same when published.
When I set the cross filter to "single" and use the DAX function CROSSFILTER in it's place, it still fails on the Server after a refresh.
How would I delete a data set on PBI web?
Do you mean delete the entire dashboard and then republish?
Thanks for your advice.