Forum Discussion

phorfanos's avatar
phorfanos
Frequent Visitor
3 years ago
Solved

Unable to open PowerBI Desktop

I received the following error message: "Cannot have SecurityFilterBehavior set to BothDirections when the relationship is not set to active".  Detailes copied and pasted below: Feedback Type: Fro...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    phorfanos , Do not directly open the file. Open power bi desktop and then open file. If it opens disable the join.

     

    Increase Data Management cache to 8-10 GB before that using blank file

    file-> Options & Settings -> Options

     

     

     

    if this does not work, log an issue too - https://community.powerbi.com/t5/Issues/idb-p/Issues

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

phorfanos , Do not directly open the file. Open power bi desktop and then open file. If it opens disable the join.

 

Increase Data Management cache to 8-10 GB before that using blank file

file-> Options & Settings -> Options

 

 

 

if this does not work, log an issue too - https://community.powerbi.com/t5/Issues/idb-p/Issues

  • phorfanos's avatar
    phorfanos
    Frequent Visitor
    2 years ago

    Unfortunately it happened again and it doesn't work. I mean I cannot open the pbix file no matter what. Any other way to access somehow the file change the SecurityFilterBehavior to something else but both direction?