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...
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