API programmatic access to dashboard tile data

[aallegri1]

Hi all,

we need to get data from a dashboard tile programmatically (REST APIs and/or PowerBI Client APIs), "simulating" the "Export to csv" functionality. Looks like if an API exists it's not public. We would also like to get access to the "embedData" property of the tile object , but it is returned empty by the GetTile API call. 

Questions:

• Any chance to run the dashboard tile "export to csv" functionality by an API (or make such an API public if currently private)?
• How can we get programmatically access to the data of a dashboard tile or get the data from the corresponding report keeping data and filters at the pin point in time?
• Any suggestions on how to extract data and context from a tile without necessarily get to the underlying report?

Thanks in advance!

[v-ssriganesh · Accepted solution]

Hello @aallegri1,
Thank you for reaching out to the Microsoft Fabric Community Forum.

After thoroughly reviewing the details you provided, I’ll address each of your questions directly based on the current Power BI API capabilities.

• There is no public API in the Power BI REST APIs or Power BI Client APIs that supports the “Export to CSV” functionality for a dashboard tile. The “Export to CSV” feature is a client-side UI function and is not exposed programmatically. There’s no indication of a private API for this purpose being available or planned for public release.

• There is no API to directly access the data of a dashboard tile or retrieve the filter state at the time it was pinned. The Get Tile API (GET https://api.powerbi.com/v1.0/myorg/dashboards/{dashboardId}/tiles/{tileId}) returns metadata such as id, title, reportId, and datasetId, but the embedData property is empty and does not contain filter or data context. No API exists to extract tile data or pinned filter states programmatically.

• There is no supported method in the Power BI REST APIs or Client APIs to extract data or context directly from a dashboard tile without accessing the underlying report or dataset. The Get Tile API does not provide tile-specific data, and the embedData property is empty, offering no context or data access.

We suggest submitting a feature request via the Microsoft Fabric Ideas portal (https://ideas.fabric.microsoft.com/) to request a public API for tile-level CSV export. This will help Microsoft prioritize the feature for future releases.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

[aallegri1]

Hi all,

we need to get data from a dashboard tile programmatically (REST APIs and/or PowerBI Client APIs), "simulating" the "Export to csv" functionality. Looks like if an API exists it's not public. We would also like to get access to the "embedData" property of the tile object , but it is returned empty by the GetTile API call. 

Questions:

• Any chance to run the dashboard tile "export to csv" functionality by an API (or make such an API public if currently private)?
• How can we get programmatically access to the data of a dashboard tile or get the data from the corresponding report keeping data and filters at the pin point in time?
• Any suggestions on how to extract data and context from a tile without necessarily get to the underlying report?

Thanks in advance!