Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
sivaadityat
Frequent Visitor

User level security with Direct query datasets

Hello experts,

 

I have a requirement in Power BI and need help.

 

Requirement: I need to connect dataset with user level security as direct query in power BI and once the report is created and published the dashboard should pick the security features from dataset. We dont not wanted to manage them with Power BI RLS.

 

sivaadityat_0-1712156805327.png

 

Please suggest me any ideas how can I do this in Power BI.

 

Thanks

2 REPLIES 2
ToddChitt
Super User
Super User

How are you securing the data at the source? Are you using SQL Server? Do you have Row Level Security set up?

And why is RLS in Power BI not an option?




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





Hello Todd,

 

How are you securing the data at the source?

I am using SQL AP's in sourcee level to secure the data. 

 

why is RLS in Power BI not an option?

This is one of the initial requirement. So, looking for solution as per requirement.

 

Hope I answered your questions above. Please suggest me anything I can do for my requirement.

 

Thanks,Siva

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.