Forum Discussion

ginoroy's avatar
ginoroy
Frequent Visitor
5 years ago
Solved

Power BI Admin API - Get Datasets

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 d...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    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.

v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

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's avatar
MURTAZA
Resolver I
4 years ago

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