I'm trying to open a .pbix file but I get an error like "SecurityFilterBehavior can't be on BothDirections when the relation is not Active" between two columns of two tables.
Then PowerBI returns to the first screen without loading the file.
How can I fix please?
2 Comments
- AnonymousNot applicable
Hi bmp_user
Did you create this pbix file? Does it open on other people's computers with the same prompt?
Maybe you can turn off Automatic relationship updates in options and then open the pbix file again.Best Regards,
Community Support Team _ Ailsa Tao - bmp_userNew Member
Hi Anonymous
yes I created this pbix file and the same error appears to everyone trying to open it.
I tried to turn off the Automatic relationship (in empty PowerBI screen since I can't open the file) and tried all other options as well, but then when I try again to open that pbix file nothing changes.
Meanwhile, I recovered a backup file form the TempSaves folder, loosing only last updates but a huge amount of work in any case.
Thanks