Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Sakshi
Helper I
Helper I

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).

1 ACCEPTED SOLUTION

API version 2.0.11 resolved my issue. Thanks

View solution in original post

4 REPLIES 4
v-micsh-msft
Employee
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

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.

 api Tile class.PNG 

 

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?

Could anyone suggest on this?

API version 2.0.11 resolved my issue. Thanks

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.