roles
19 TopicsCreating and or customising user roles on Power BI report server
Hi, We are using Power BI report server March 2018. I have a dev server set up and I am trying to expand user access to allow users to create their own schedules and manage reports. It seems that I would have to assign "System Administrator" to do this. I have read other articles suggesting I can add roles and/or customise them. I can't find this facility anywhere! Is someone able to tell me how to do this? Thanks in advance Chris.Solved26KViews0likes7CommentsField 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, Ilan457Views0likes1CommentRow Level Security Issue
Hi everyone, I'm facing a problem applying a Row Level Security to my report. I have create a Rol where I filter the Countries depend on the user email. And when I click on test a role it works. Then when I publish the report on the workspace I can see the Role created. But the issue comes when anyone opens it and It is not filtered by the country of the person who is watching it. It is as if the role had not been applied. Do you know if i have to change anything on my workspace/report/database settings? Thank you, Regards.Solved872Views0likes1CommentManaging Report Access: Difference between a Reader and a Viewer?
Hi, Wondering what the difference between "Reader" and "Viewer" is? I'm not sure how I ended up creating the different roles, but essentially, I want the people I grant access to be able to view the report only (disabled accessing the dataset and editing). Thank you in advance.Solved2.6KViews0likes2CommentsPower 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 advance3.5KViews0likes2CommentsSharing dashboards with clientes outside our VPN
Hi community, I've encountered an issue, I would like to share a dashboard with a client outside my organization and I was searching for a possibility to share it with them without giving them access to the VPN. I would like also to restrict access with Row-level security since i will have 50 customers and only 5 will have acess to the full dashboard. The data is very sensitive Does anyone knows if this is possible? I'm willing to buy premium license Thanks in advance, Rodrigo1.4KViews0likes2CommentsRole Level Security does not add several users at once
Hello, I have a exclusive situation where I cannot add a group of users anymore due to conflict of particular user who has to be in another role. However when I try add and Save 60+ user at once the message below appers after several minutes of loading. Same happens when I try add 10 users at once for exemple. Something went wrong The role could not be updated. Please try again later. Please try again later or contact support. If you contact support, please provide these details.Hide details Activity ID47e4c79d-2d59-43f3-b80b-83711a2cc07b Request ID3df3c461-2fcb-26e3-6cb3-29ca7f8b0db7 Correlation ID2f17c95c-6707-14fe-a3a3-531ebb48aa7f Status code500 TimeFri May 21 2021 08:33:18 GMT-0300 (Brasilia Standard Time) Service version13.0.16039.63 Client version2105.1.06194-train Cluster URIhttps://wabi-europe-north-b-redirect.analysis.windows.net/Solved983Views0likes2CommentsData driven subscription permission issue
Hi, There's a requirement for users who are not report server administrators to be able to create data-driven subscirptions. When they attempt to create this subscription, they get a permission insufficient error. I've read in MS docs that Data-driven subscriptions are typically created and maintained by report server administrators. As the report server administrator, I can create the subscription with no problem. However, I do not want to give users admin access. In this article: https://docs.microsoft.com/en-us/sql/reporting-services/subscriptions/create-modify-and-delete-data-driven-subscriptions?view=sql-server-2017, it mentions that the author of the subscription must have permission to "Manage reports" and "Manage all subscriptions. I think this can be accomplished by creating a custom role. I've tried following this article: https://docs.microsoft.com/en-us/sql/reporting-services/security/role-definitions-create-delete-or-modify?view=sql-server-ver15. To create a role definition in SSMS, I go to the reportserver database>expand the Roles folder. I only see a Database Roles folder and an Application Roles folder. How do I assign the "Manage reports" and "Manage all subscriptions permissions to a role? Also, I do not see the predined roles in the Database Roles folder or the Application Roles folder. Is this the right location?Solved1.7KViews0likes1CommentHow to manage data access with DAX
Hi! I need to manage access control over the data in my dashboard. There are multiple countries reporting data. One country in particular (SRO) has sensible data and therefore can only be accessible to members working there. I've created a table where organization members' emails are associated with each of their respective countries. Now, what DAX expression would allow me to specify that only members that login with an email associated to SRO should have access to SRO data? I hope this makes sense, Thanks!860Views0likes1CommentNew item role does not appear in report server portal
Hello - I have installed Power BI Report Server May 2020. Using SSMS I connected to the report services and created a test role. From within the portal, when I manage a report or folder under security, the new role does not appear in the list. I am a system administrator and I have re-started the Power BI Windows sevice on the server. Thoughts? Thank you.Solved4.9KViews0likes15Comments