cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MohanV Established Member
Established Member

RLS on Report Server KPI

I did created a kpi in report server using SSAS cube as my data source.

And Roles are aleady defined in that cube and it is working fine for each users for power bi reports.

 

First, I did created a shared dataset using reprot builder of that cube and then by using that dataset i created kpi in report server.

I did tried to find out the ways to implement rls for these kpi's but i couldnt.

 

Can any one please help me how to implement RLS on KPI's and Paginated reports in powerbi report server

 

Thanks,

Mohan V

5 REPLIES 5
Gudmas Frequent Visitor
Frequent Visitor

Re: RLS on Report Server KPI

Hi Mohan January update of the Power BI Report Server has support for RLS

https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-update-january-2019/

 

But I have not tried it yet.

MohanV Established Member
Established Member

Re: RLS on Report Server KPI

Thanks for the reply @Gudmas,

But this is not about Report level RLS.

 

We can create KPI's using Report Builder by creating some shared/embedd datasets in report server.

 

For those KPI's and Paginated reports, how we can implement RLS.

 

Any help.

 

 

 

adrez86 Regular Visitor
Regular Visitor

Re: RLS on Report Server KPI

I believe Report Server only supports RLS on Power BI reports right now. If you're using a live connection through your SSAS datasource then this may help you setup RLS on SSAS side

MohanV Established Member
Established Member

Re: RLS on Report Server KPI

Thanks for the reply @adrez86.

 

FYI, i did these things already, and i have successfully published more than 50 reports till now in my organization.

But I am trying to make dashboard kind of user experience(Like in powerbi service) in report server by creating these KPI's and paginated report visuals.

 

So, thats the reason im trying to get implement RLS for these KPI and all.

 

I didnt understood one thing, that, whats the use of giving KPI as an option if ther's not proper RLS is not applied to these.

 

Just asking.

 

Any help.

 

adrez86 Regular Visitor
Regular Visitor

Re: RLS on Report Server KPI

Power BI reports didnt have proper RLS until last week so would you ask why would they give us Power BI reports without proper RLS? They're always adding new things.

 

You can suggest new ideas here

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 84 members 1,432 guests
Please welcome our newest community members: