Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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..
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
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".