API to pull data and images from PowerBI - e.g., get data from Dataset (e.g., as CSV, JSON)

[erik18]

API to pull data and images from PowerBI: - get list of Reports, Dashboards - get data from Dataset (e.g., as CSV, JSON) - get data from Report - get image of visualization PowerBI has 3 types of objects: - Datasets. They contain pure data, just rows. - Reports. It's visualizations for data. Actual state of report can be pinned to dashboard. - Dashboard. Set of pinned visualizations. PowerBI API allows get list of Datasets and push data into them. Getting list of Reports is not supported. So request is for: API to pull data and images from PowerBI: - get list of Reports, Dashboards - get data from Dataset (e.g., as CSV, JSON) - get data from Report - get image of visualization e.g., for - get data from Dataset (e.g., as CSV, JSON) I tried to send HTTP GET to https://api.powerbi.com/beta/myorg/datasets/{dataset_id}/table/{table_name}/rows but server returned 404 error code. From http://stackoverflow.com/questions/30124663/power-bi-rest-api-import-data/30170158

[diego18]

I like this idea. I also believe the API should allow the creation and retrieval of dashboards' tiles (I've just submitted those ideas) so that we could access a static image of the current snapshot.

[colin2]

Yes, we have a lot of clients who would be able to use this to pull data.

[rpe]

Would also like to be able to grab the data from a tile via API (instead of manually via the Export Data option)