Forum Discussion

Sakshi's avatar
Sakshi
Icon for Helper I rankHelper I
8 years ago
Solved

To retrieve ReportId and DatasetId with other tile details while fetching data from Power BI API

Is there a way to fetch ReportId and DatasetId as well from API while fetching tiles data using 'GetTilesInGroupAsyn' method defined in Microsoft.PowerBI.Api.V2 namespace.

Required to be accessible for app generated for non-Power BI Users(i.e. using app owns data).

  • API version 2.0.11 resolved my issue. Thanks

4 Replies

  • v-micsh-msft's avatar
    v-micsh-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    The returned JSON for Get Tiles API would give the reportId and the DatasetId:

    Check the API reference:

    Get Tiles

     

    The corresponding Tile data is stored under the ODataResponseListTile.Value property, which should be a Tile list.

    For the Tile class, see:

    Tile class

     

    For example, to get the first tile ReportId:

     

    using Microsoft.PowerBI.Api.V2; 
    using Microsoft.PowerBI.Api.V2.Models;
    // To retrieve the tile, you first need to retrieve the dashboard.
    // You will need to provide the GroupID where the dashboard resides.

    ODataResponseListDashboard dashboards = client.Dashboards.GetDashboardsInGroup(GroupId);

    // Get the first report in the group.

    Dashboard dashboard = dashboards.Value.FirstOrDefault();

    // Get a list of tiles from a specific dashboard

    ODataResponseListTile tiles = client.Dashboards.GetTilesInGroup(GroupId, dashboard.Id);

    // Get the first tile in the group.

    Tile tile = tiles.Value.FirstOrDefault();

    //Get the first tile ReportId

    string rptId = tile.ReportId
    or
    string rptId = tiles.Value[0].ReportId

     

     

    Regards,

    Michael

    • Sakshi's avatar
      Sakshi
      Icon for Helper I rankHelper I

      Hi v-micsh-msft

       

      Thanks for the reply.

      I am using the same approach but Tile class does not have ReportId and DatasetId properties in API version 2.0.2. See screenshot attached.

        

       

      I am not sure but I think this version of API does not return these properties. Let me know if this is the case which API version should I use which will suffice all my needs or still am I missing something?