Forum Discussion
Getting report name,url and dataset user using powershell
Hello everyone, my requirement is to obtain the report name, report URL, and the Dataset user. The dataset contains Row-Level Security (RLS), and I need to determine which user has access to which report. I intend to achieve this using PowerShell and export the output to an Excel file.
3 Replies
- ibarrauSuper User
Hi. You can get some info about the report using the following cmdlets:
However there is no way to obtain RLS data from any request.
You can also use the PowerBi Rest API: https://learn.microsoft.com/en-us/rest/api/power-bi/reports/get-reports-in-group
There are libraries like SimplePBI for python to make it easier.
I hope that helps,
- AzaharoddinSkFrequent Visitor
Hi ibarrau
Can I get Dataset users of that report by using Powershell- ibarrauSuper User
Sure. You can use this request for PowerBi API requests besides the ones built at power bi cmdlets
I hope that helps