cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shanawazsheriff New Member
New Member

Paginated reports row level security

Hi All,
We have started using paginated reports within powerbi service recently. Our data source is Azure sql server. We are looking for a way to have row level security in paginated reports. The users have been added in different AD groups as per their roles and access levels. Could someone please advise what options i could try to filter the data based on the powerbi service login ? And how do i pass the powerbi service login to database ? Or please suggest some other ways to achieve RLS in paginated reports.
Thanks,
Shanawaz
6 REPLIES 6
Community Support Team
Community Support Team

Re: Paginated reports row level security

Hi @shanawazsheriff ,

Current RLS only works on report server or database side, you can't enable RLS on paginated report.

For your requirement, you can submit an idea for this requirement.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Power BI Team chrisfin
Power BI Team

Re: Paginated reports row level security

RLS is available if you're using Azure Analysis Services or Power BI datasets.  Azure SQL database will support RLS by the end of June

Shwetha_ps Frequent Visitor
Frequent Visitor

Re: Paginated reports row level security

Could you please advise if tehre has been any updates on the RLS for Azure SQL database ?

Highlighted
Power BI Team chrisfin
Power BI Team

Re: Paginated reports row level security

You should see this supported via oAuth for Azure SQL db by the end of the week (or weekend).

shanawaz777 Frequent Visitor
Frequent Visitor

Re: Paginated reports row level security

Could you please advise if there has been any update on having row level security on paginated reports connected to Azure SQL database ?



 

Power BI Team chrisfin
Power BI Team

Re: Paginated reports row level security

Yes, you should be able to use oAuth and check the box for users to connect under their identity.  It's covered in the documentation - https://docs.microsoft.com/en-us/power-bi/paginated-reports-data-sources

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 103 members 1,586 guests
Please welcome our newest community members: