Field Parameter
Hi, I am using PBI RS with direct query to Tabular with roles. We want to show a different set of columns in an simple table object depending on roles permissions. Field Parameter seems to be the perfect match ! Is there any plan to include "Field Parameters" in Power BI Report Server ? Thanks and Regards, Ilan
Power BI Report Server - Role and permission
Hi, I am aware of the available MS doc : Role definitions - predefined roles - SQL Server Reporting Services (SSRS) | Microsoft Docs that I read carefully but I find it a bit confusing, mainly because the roles and their associated tasks are shared between SSRS and Power BI RS... a bunch of tasks are related to features that aren't even available in Power BI RS ! I am also aware I can customize any role, but I'd prefer to use predefined ones if they are sufficient. Could you please help me to understand better : 1) Let's say a given user has both a Browser and Publisher role on a Folder. Can he manage (delete for instance) EVERY reports and subfolders present in the folder, or only the ones he owns ( = he's the creator of) ? If the answer is yes, what is the difference with a Content Manager ? Only the possibility to manage role and permission for that folder ? 2) Same scenario, but the user has only the Publisher role. On this folder, does it mean the user won't be able to see any reports that he doesn't own ? What happened if he delete a subfolder that contains reports he doesn't own and thus doesn't see ? Any help would be appreciated, Thanks in advance
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 muchPBI Report Server security to SSAS-T model
Hello I have this scenario: 1. SSAS-Tabular model in a server. 2. Power BI report created with Power BI Desktop (March 2018) with Connect Live to the tabular model. 3. A local Power BI Report Server. I would like the users of the report to use their credentials to visualize it through the Report Server (because I define roles in the cube). I go to Manage-> DataSource and I try this different options: If I select "Windows Authentication" and "As the user viewing the report", doesn't work: Data source AnalysisServices is not supported. If I select "Use the next credentials" and check "Log in using these credentials, but then try to impersonate the user viewing the report", doesn't work: The 'DOMAIN\user' value of the 'EffectiveUserName' XML for Analysis property is not valid. If I select "Use the next credentials" works fine. With the option 1, I can see this error on the visualization: "To connect as the user who is viewing the report, the organization must have Kerberos limited delegation configured." How should the datasource be configured for the user to pass their credentials so that the roles can be applied? ThanksDynamic Row Level Security (RLS) in SSAS Tabular cube for Power BI Report
We have defined 3 roles in SSAS Tabular Cube 1-role) Admin 2-role) StandardUser 3-role) SuperUser. I am included in all the 3 roles. In the power bi report server StanderdUser is working fine by giving limited access to the data. Could you please let me know if I login as Admin it should by-pass StandardUser & SuperUser and show me logged in as Admin using DAX Query or any other suggestions if possible. Also we want to show a message to the users when the user logins in it should show the message that you are a Admin or standarduser or superuser.
