Getting report name,url and dataset user using powershell

[AzaharoddinSk]

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.

[AzaharoddinSk]

Hi @ibarrau 
Can I get Dataset users of that report by using Powershell 

[ibarrau]

Sure. You can use this request for PowerBi API requests besides the ones built at power bi cmdlets

https://learn.microsoft.com/en-us/powershell/module/microsoftpowerbimgmt.profile/invoke-powerbirestm...

I hope that helps

[ibarrau]

Hi. You can get some info about the report using the following cmdlets:

https://learn.microsoft.com/en-us/powershell/module/microsoftpowerbimgmt.reports/get-powerbireport?v...

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,