Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to Solution.
Hey @Anonymous ,
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
Hey @Anonymous ,
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
44 | |
33 | |
28 | |
26 | |
23 |
User | Count |
---|---|
39 | |
33 | |
20 | |
19 | |
15 |