Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi Community,
We have create a report using dynamic M query datetime parameter so that whatever value in slicer will be selected it acts at joining condition in the query itself. Now I have security table in my database and I want to implement RLS in this report.
Case 1) Security table we have connect with query dataset which contains datetimes parameter, but RLS is not working.
Case 2) Security table we have connected it to another table let say branch table that we imported which will bring slicers values and does not contains parameters and this branch table is connect to query dataset which contains parameters, but here also RLS is not working.
Can you please help on this....
Thanks in advance!!!
Solved! Go to Solution.
Hi @Anonymous ,
It's a known limitation. Currently,Row-level security (RLS) is not supported with the feature.
For more limitations about Dynamic M query parameter and RLS, please refer to this document.
considerations-and-limitations
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
It's a known limitation. Currently,Row-level security (RLS) is not supported with the feature.
For more limitations about Dynamic M query parameter and RLS, please refer to this document.
considerations-and-limitations
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
64 | |
55 | |
53 | |
36 | |
34 |
User | Count |
---|---|
85 | |
73 | |
55 | |
45 | |
43 |