Forum Discussion

JojoPBI's avatar
JojoPBI
New Member
2 years ago
Solved

PBI API - Retrieve the dataset ID of a paginated report

Hello,   Using the Power BI API, I'm trying to get the Dataset IDs of my dashboards and paginated reports, in order to get the schedule for those datasets. Paginated reports are using dahsboards Se...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    The GUID in the database attribute is the ID of the semantic model.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Dashboard => Report

 

Semantic Models are SSAS Tabulair data sources.   Can you show a sample output?

  • JojoPBI's avatar
    JojoPBI
    New Member
    2 years ago

    This is what I'm getting using the reports/get-datasources-in-group on a paginated report with a power bi dashboard datasource:

    {'@odata.context': 'https://wabi-north-europe-c-primary-redirect.analysis.windows.net/v1.0/myorg/groups/854896c8-90da-4a0f-82f5-4448c5afd379/$metadata#datasources', 'value': [{'name': 'DashboardsB2BFrance_EtatdeslieuxTeamMemberGCPublic', 'datasourceType': 'AnalysisServices', 'connectionDetails': {'server': 'pbiazure://api.powerbi.com/', 'database': 'sobe_wowvirtualserver-38fec1cc-26ff-4d35-9fa2-b9432efd2bb4'}, 'datasourceId': '212bbd5e-3267-4082-9e8c-44b23ce770f3', 'gatewayId': '5c4e0146-aa7a-4d52-b261-9ef8500cc23a'}]}

     

    Screenshot of my rdl report and its datasource:

     

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      The GUID in the database attribute is the ID of the semantic model.

      • JojoPBI's avatar
        JojoPBI
        New Member
        2 years ago

        Oh, I completely missed checking what that id was, it is indeed the semantic model ID.

        Thanks a lot!