How to Batch Add User Permissions to a Report in Power BI Report Server
I need to add permissions for users in the reports on Power BI Report Server. There are more than 1000 users that need to be added, and I have a list of users. However, due to IT restrictions, I cannot use AD. Currently, I can add them one by one in the web portal, but since there are so many users, adding them this way is very cumbersome. Therefore, I need to add them in bulk. Additionally, for Row-level security (RLS), it is also necessary to add user permissions in bulk. I think it's not possible to achieve this through the UI interface and would need to use API calls or programming methods to accomplish this. After reviewing the following three official documents, it seems that there is no API information regarding this operation. 1. Modify or delete a role assignment (SSRS web portal) => Modify or delete an item role assignment https://learn.microsoft.com/en-us/sql/reporting-services/security/role-assignments-modify-or-delete?view=sql-server-ver16#modify-or-delete-an-item-role-assignment 2. Row-level security (RLS) in Power BI Report Server => add-members-to-roles https://learn.microsoft.com/en-us/power-bi/report-server/row-level-security-report-server?source=recommendations#add-members-to-roles 3. Developer handbook overview, Power BI Report Server => API https://learn.microsoft.com/en-us/power-bi/report-server/developer-handbook-overview#apis Furthermore, I am very regretful to see that the Power BI Service API does not include an API for adding users to reports. Based on this description, it is very likely that Power BI Report Server also does not have this API Re: Add users access on a specific report/Data in ... - Microsoft Fabric Community Could you please let me know if the above requirements can be met? How can they be achieved? Or, Is there a way to add 1,000 users in bulk to a group using PowerShell on Power BI Report Server? This way, I only need to add one group in the Portal.
why parameter definitions is not showing for shared dataset in power BI report server
Hi, When I'm calling the API for getting parameter definitions I'm getting an empty array, http://ServerName//reports/api/v2.0/Datasets(dataset_id)/parameterDefinitions { "@odata.context": "http://servername/reports/api/v2.0/$metadata#ParameterDefinitions", "value": [] } But I've set the parameters in the shared dataset How to resolve it Thanks in advance.How to get data from based on based on passed Parameter passed on the report server
Hi, I have created the parameter in the data set and I can get the data based on the parameter passed on the report in the SSRS when I deploy to the Power BI report server I'm getting the following error. An error has occurred during report processing. (rsProcessingAborted) An attempt was made to set a data set parameter '@BrandName' that is not defined in this data set. (rsUnknownDataSetParameter). How to resolve it?
