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

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.

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

FarhanAhmed 

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.