Extracting dataset owners using Power Shell script

[Ynr0225]

Hello Team,

Is there a way to extract dataset owners using Power Shell script. If it is possible please send me the Powershell script.

Thanks in advance!

[TomMartens · Accepted solution]

Hey @Ynr0225 ,

here you will find a Powershell script:

Import-Module -Name MicrosoftPowerBIMgmt

# Connect as Serviceadministrator
Connect-PowerBIServiceAccount

$datasetID = " ... your datasetid goes here ..."
$uriAPICall = "https://api.powerbi.com/v1.0/myorg/datasets/$datasetID/users"
$uriAPICall_Obj = Invoke-PowerBIRestMethod -Url $uriAPICall -Method GET

$uriAPICall_Obj

Disconnect-PowerBIServiceAccount

Read here about the API function endpoint: 
Datasets - Get Dataset Users - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Hopefully, this will help to tackle your challenge.

Regards,

Tom