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.
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).
Solved! Go to Solution.
The returned JSON for Get Tiles API would give the reportId and the DatasetId:
Check the API reference:
The corresponding Tile data is stored under the ODataResponseListTile.Value property, which should be a Tile list.
For the Tile class, see:
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
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?
Could anyone suggest on this?
API version 2.0.11 resolved my issue. Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |