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

[Anonymous]

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..

[v-qiuyu-msft]

Hi @Anonymous,

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-hosting/m-p/188678

Best Regards,
Qiuyun Yu

[Anonymous]

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".