Forum Discussion
yogevz
9 years agoHelper II
Can't Get RLS to Work
Hi all help!!!!!!!!!! can't get the RLS to work. i tried even just 1 table with 3 rows and nothing. can somebody attach 1 small powerbi file with basic RLS which works? i will take this file and...
- Anonymous9 years ago
Hi yogevz,
My suggest is use an intermediate table to link these tables.
Reference link:
How to create many to many relationships
Regards,
Xiaoxin Sheng
yogevz
9 years agoHelper II
Hi
i succeed doing the RLS.
now - new issue.
from one side - users and department
from second side - fact table, every department has several of rows (table has history).
now - i can't create join between the tables!
powerbi doesn't permit join between 2 tables with many values (many to many).
what now??
Anonymous
9 years agoNot applicable
Hi yogevz,
My suggest is use an intermediate table to link these tables.
Reference link:
How to create many to many relationships
Regards,
Xiaoxin Sheng