The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 @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
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
75 | |
36 | |
33 | |
23 | |
14 |