A S on 01 May 2015 13:15:09
Pretty self explanatory - would be great to be able to stream a dataset, or grab a specified number of rows.
This would also require the ability to query the # of rows, size of dataset etc, column types etc.
somewhat related to this feature request: https://support.powerbi.com/forums/265200-power-bi/suggestions/7059563-create-a-part-download-of-datasets
Administrator on 07 Sep 2022 17:08:04
Now available via the ExecuteQueries REST API - https://powerbi.microsoft.com/en-us/blog/announcing-general-availability-of-the-executequeries-rest-api/
- Comments (29)
RE: REST API access to READ datasets
'+1
RE: REST API access to READ datasets
'+1
RE: REST API access to READ datasets
Not sure why you would even build the ability to write rows to a dataset table but not build the ability to read rows from it!?!? Strange. Also there is no ability to get a user's "Favorites" or get access to a users recent reports or get access to the filters that a user has applied to a particular report. I wanted to access a users "Favorite" reports so that I can allow them to click them from our custom app. The data is not available so I thought I would allow users to build their own favorites from my app by sticking their selected values in a dataset table (do not want database attached to this app) and the use that for these records. Not available. It seems like every time I try to build something out using the APIs, I always run into some road block. API is to young for production I am afraid.
RE: REST API access to READ datasets
Gareta summed up the need for this perfectly below. We are doing a lot of transformation of data in Power BI which is then needed for other applications without having to duplicate these transformations again.
RE: REST API access to READ datasets
'+1
RE: REST API access to READ datasets
We really need this. The company is moving to some cloud products where the only way to get data is via REST APIS. It is increasing my dependency on Development.
RE: REST API access to READ datasets
when trying to GET Tables of DataSet which created in power API Desktop.
The API return 404 with error: "Dataset {dataset_id} is not Push API dataset."
I have posted this issue which marked as "Delivered"
http://community.powerbi.com/t5/Issues/Can-t-reach-Tables-Columns-Relationships-of-a-DataSet/idc-p/190127#M8804
RE: REST API access to READ datasets
'+1
RE: REST API access to READ datasets
This is required as we want to pull data from a custom registered client application.