Rest Power BI API - Get information from users, data sources, tables and fields, and so on.

Hi Syndicate_Admin ,

I wrote some code to get the metadata for the workspace. The logic is:

1. Obtain dynamic access token.

() =>
let 
    body = "grant_type=password&&resource=https://analysis.windows.net/powerbi/api&&response_type=code&&client_id=xxxxxxxxx&&client_secret=xxxxxxxxx&&username=xxxxxxxxx&&password=xxxxxxx",
    Data=Json.Document(Web.Contents("https://login.microsoftonline.com/common/oauth2/token/",
        [Headers=[#"Content-Type"="application/x-www-form-urlencoded"], Content=Text.ToBinary(body)])),
    access_token = Data[access_token]
in 
    access_token

2. Call Groups GetGroupsAsAdmin api to return the list of workspaces and then merge those IDs.

3. Call WorkspaceInfo PostWorkspaceInfo api and reference the workspace IDs from the previous step and return the scan ID.

() =>
let 


    Source = Json.Document(Web.Contents("https://api.powerbi.com/v1.0/myorg/admin/groups?$top=3", [Headers=[Authorization="Bearer "& GetAccessToken() ]])),
    value = Source[value],
    #"Converted to Table" = Table.FromList(value, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"id", "isReadOnly", "isOnDedicatedCapacity", "capacityMigrationStatus", "description", "type", "state", "name"}, {"id", "isReadOnly", "isOnDedicatedCapacity", "capacityMigrationStatus", "description", "type", "state", "name"}),
    GroupID = """" & Text.Combine(#"Expanded Column1"[id],""",""") & """",
    body = "{ ""workspaces"": [ " &  GroupID &  " ]}",
    Data=Json.Document(Web.Contents("https://api.powerbi.com/v1.0/myorg/admin/workspaces/getInfo?datasourceDetails=True&datasetSchema=True&datasetExpressions=True&getArtifactUsers=True",
        [Headers=[Authorization="Bearer "& GetAccessToken(),#"Content-Type"="application/json"], Content=Text.ToBinary(body)])),
    scanID = Data[id]
in 
    scanID

4. Call WorkspaceInfo GetScanStatus and reference the scan ID from the previous step. if the status value of the response is "Succeeded", proceed to the next step.

() =>
let 
    Data=Json.Document(Web.Contents("https://api.powerbi.com/v1.0/myorg/admin/workspaces/scanStatus/" & PostWorkspaceInfo(),
        [Headers=[Authorization="Bearer "& GetAccessToken()]])),
    Scan_ID = if Data[status] = "Succeeded" then Data[id] else "Scan failed"
in 
    Scan_ID

4. Call WorkspaceInfo GetScanResult to return the metadata of the workspaces.

let
    Source = Json.Document(Web.Contents("https://api.powerbi.com/v1.0/myorg/admin/workspaces/scanResult/" & GetScanStatus(), [Headers=[Authorization="Bearer "& GetAccessToken() ]]))
in
    Source

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-kkf-msft 

Is there a way to add "Date Created" for the artifacts like Reports, Dashboards, Workspaces, Datasets and Dataflows? (admin) tables

Questions from my previous post:

1. Can we set dataset schedule refresh if we publish the report created to the service? if yes, can you please help me how ?

2. Can we only scan with Tenant Admin account (Deligated Admin)? (is there a way to use Service Principal (client ID and Secret)

3. Tables inside Experimental folder taking hours and hours to load. "Dataflow Users" table gives "Access Forbidden" error.

Thanks in advance.

Hi v-kkf-msft ,

Any update to this connector?