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.
Setting PBI report policies with .Net OData client
Hi! In our company we have a lot of reports with a dozens of users, therefore we would like to automate the policy setting with a small .Net application in VS2019. First I configured a connected service with ,,OData Connected Service'' extension in the project. That works fine until a try to load the policies for a specific report, but in the last step a recieve an error message: ,,A property with name 'Id' was found when reading a top-level resource set. No properties other than the resource set property with name 'value' are allowed.'' Here is my code: using System; using System.Linq; using Model; // this is the namespace of the automatically generated OData client namespace ODataTest { class Program { static void Main(string[] args) { var context = new Container(new Uri("https://my.company.com/Reports/api/v2.0")); context.Credentials = System.Net.CredentialCache.DefaultCredentials; PowerBIReport ci = context.PowerBIReports.Where(c => c.Path.Contains("SampleReport")).Single(); context.LoadProperty(ci, "Policies"); // ERROR } } } the last line throws the error. I also tried the ,,expand'' method but it is not working with the report servers API. In my understanding the a LoadProperty command expects a json response like { "values":[ { "GroupUserName":"DOMAIN\User1","Roles":[ { "Name":"Content Manager","Description":null } ] }, .... ] } however the a server send a response like this: { "@odata.context":"https://my.company.com/Reports/api/v2.0/$metadata#Collection(Model.ItemPolicy)", "Id":"00000000-0000-0000-0000-000000000000", "InheritParentPolicy":true, "Policies":[ { "GroupUserName":"DOMAIN\User1","Roles":[ { "Name":"Content Manager","Description":null } ] }, .... ] } Can You help to solve this issue? Thanks! best, Gallusz p.s.: as a last resort I can do policy setting with pure put request, but I think the proper way is to use the OData client library with the connected serviceHow to launch a report from a dashboard
FYI I am new to this! I have a dashboard (powerbi embedded) that I want to add a report to. What I would like is for the user to be able to slice and dice the dashboard as needed, then have an 'Export' button on the dashboard that will pop-up a window that shows the associated report filtered to the user's selection. From there, the user can save the data as XLSX. I see there is a report widget, which looks like it will handle most of the above just fine, however I do not want it taking up my screen real estate all the time. Ideally the report widget would be hidden and then an export button would unhide it, and then it would hide again when the user clicks away, but I don't see that type of hide/unhide control available. Curious to see what my option are or how others launch reports from dashboards? Thanks for any ideas!!
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?
