Exclude Users from Ranking RANKX
Jolly Day, I am needing to exclude three users from being included in the ranking. What I currently have just inserts a dash where there ranking number would be and are still being ranked. Could someone help me with a measure to completely exclude them? Entry Rank = IF(SELECTEDVALUE (System_Users[Account]) IN {"cbelcher","pkessell","kcole"}, "-", RANKX(ALL(System_Users),Audit[Sum Entry]) ) Many thanks in advance!
Export to excel not working regularly for some users in the organization
Hello, i am having an ssue while trying to export data to excel from power bi, i know my permissions and settings are correct since it work for some users but for some users in the oranization, it sometimes work and sometimes when pressing the export button, nothing happens or it getting loading for 10minsand no excel is downloaded or viewed. Please note that i am a premium user. Thank you in advaced !Manage security and RLS with custom authentication
Hello everybody, I am a bit new in Power BI Report Server. I installed my evaluation trial and configured with reports and Windows users fine. Then I needed to use custom authentication, so I tried to get it as explained in https://github.com/Microsoft/Reporting-Services/tree/master/CustomSecuritySample#start-of-content and in the end it worked fine. I created clicking on "Register new user" of login window, then I added it in Security element in RSReportServer.config file (step 3 of the article) and finally I could login. When I am in the Report Server, I see reports, I can manage security on first page and choosing Element roles and System roles, but a lot of things are not working as it always tells me "An error occurred. Try later": I can't open the Menu of any report, where I could manage RLS, updates, title and so on clicking on right-upper corner I can't open any report I can manage Element and Security roles but they look not to work as I gave me Content Manager and System Administrator but I can't edit anything about reports. I don't see previous domain users anymore but maybe it's normal, but I need to configure many users and giving them permissions about folders and reports but it doesn't work. Some particular aspects which could be useful: In Report Server Configuration Manager, as Service Account I use a domain account of my server which I used before to login to Report Server too, maybe I should change? I don't know but I don't think In step 4 of the article to configure custom authentication you need to generate machine key with Validation="AES" but when I generated it with my server I got Validation="HMACSHA256" Please help me because I really need to configure it in the right way, it's very important to me. Thanks a lot Nick
Add users in basic authentication
Hello, I installed my evaluate version of Power BI Report Server on a virtual machine, then I log in with admin account and upload reports where I have roles. I need to provide access to users outside my domain, so I want to use basic authentication (it's the best way, isn't it?) defining usernames and passwords. I changed the RSReportServer.config file as explained at https://docs.microsoft.com/en-us/sql/reporting-services/security/configure-basic-authentication-on-the-report-server?view=sql-server-2017#main but now I don't know how to create new credentials and the only way I am able to connect is with my admin account. I read many things about security and roles assignment but I have no user to associate to one of my roles. Please help me. Thank you so much
How is Views by User defined in Usage Metrics?
In Report Server, after clicking on Usage Metrics, how is Views by Users defined? If I am a user, and I open a dashboard to view in Report Server, and then refresh the browser, does this count as 2 views or 1 view? Or is there some other explanations? I checked the below link but it does not explain this. https://docs.microsoft.com/en-us/power-bi/service-usage-metrics Thank you!
