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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

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!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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