Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have a dataset published with RLS setup. Access rights and RLS are setup based on mail-enabled security group. Dataset doesn't have any endorsement set.
In reports RLS works as intended. Dataset has a featured table. I would like for security group users to be able to access custom data types via excel based on this table and for RLS to restrict their access to data they do not have rights to.
Here's how it looks in my scenario:
Could you please guide me how to make custom data type based on featured table to apply RLS in excel without giving too wide dataset permissions to security group?
Thank you,
Blazej
Looking for custom data types and featured table experts 🙂
Hi. I'm not sure what you mean with Custom Data.
If you are talking about the DAX function CUSTOMDATA(), I think that only wokrs in Analysis Services.
If want to build a dynamic RLS based on an excel, you can follow this post: https://blog.ladataweb.com.ar/post/652895563673649152/powerbi-seguridad-de-filas-rls-con-regla
That will build one step by step. Instead of using excel it is hardcoding a table in Power Bi, but you could just use an excel.
I hope that helps,
Happy to help!
Hi Ibarru,
thank you for reaching out!
I am referring to custom data types in excel under Data tab:
They are a result of marking one of yor dataset tables as featured one.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.