cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lucky1012 Regular Visitor
Regular Visitor

how to use only one url instead of two url's for paramter cases

hi all,

    i have a powerbi report is save in power bi report server and deployed to report server web portal url.

here, in my report i have 2 cases one is female other male. In application i need to show female related report by clicking female tab and male report when clicking male tab. My source is tabular model(Analysis services) so i don't have option to take paramteres in report. so i decided to take report level filters "female " in first report and "male" in second report. then i can deploy 2 reports i web portal url and sync these url in front end ...is there any other way to take only one url instead of two seperate url's for single report. Please help..

2 REPLIES 2
Moderator v-qiuyu-msft
Moderator

Re: how to use only one url instead of two url's for paramter cases

Hi @lucky1012,

 

You can define roles on SSAS side, then in Power BI report server, set the credential for the data source with "As the user viewing the report". See: https://community.powerbi.com/t5/Developer/How-to-Implement-Row-Level-Security-in-on-premises-SSRS-h...

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lucky1012 Regular Visitor
Regular Visitor

Re: how to use only one url instead of two url's for paramter cases

thanx Qiuyun Yu for the reply.. but in my report "female" and "male" are values in a column not usernames.

there's a column named "CANDIDATE" and values under it are female,"male".

 

 

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (1,958)