Power BI Admin API - Get Datasets

[ginoroy]

Hi,

Does anyone know how to get the datasourceUsages info when calling the Power BI Admin apis? Using either Datasets GetDatasetsAsAdmin  or Groups GetGroupsAsAdmin  expanded with datasets. The documentation refers to a DatasoureUsage array but the api does not return any

[v-lionel-msft]

Hi @ginoroy ,

Has your problem been solved?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-lionel-msft · Accepted solution]

Hi @ginoroy ,

How did you connect to the Rest API, PowerShell or web connector?

Please show your M code in 'Edit Query' or the shell code.

Please refer to the code.

Connect-PowerBIServiceAccount

$Workspace = Get-PowerBIWorkspace -All

ForEach($Workspace in $Workspace)
{
    $Url = 'https://api.powerbi.com/v1.0/myorg/groups/'+ $Workspace.Id + '/datasets'
    Invoke-PowerBIRestMethod -Url $Url -Method Get
 }

Disconnect-PowerBIServiceAccount

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MURTAZA]

Hi @v-lionel-msft ,

I am also trying to achieve the same automation, however, this requires a user interaction to login. MFA is enabled for our tenant. and service principal with client id and client secret are unable to return Admin API. Is there a way around this? To be able to automate the process? Many Thanks 

[aj1973]

Hi @ginoroy 

I beleive this video can help you.

https://www.youtube.com/watch?v=fC6SK2TkoS0