Skip to main content

Power BI

Completed

REST API access to READ datasets

Vote (581) Share
A S's profile image

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)
A S's profile image Profile Picture

Simon Zhang on 17 May 2022 22:32:22

RE: REST API access to READ datasets

Need this feature to be available ASAP.

A S's profile image Profile Picture

Nick Chobotar on 18 Nov 2021 19:58:46

RE: REST API access to READ datasets

I am glad to see we broke the ice on this feature with this :
https://powerbi.microsoft.com/en-us/blog/announcing-the-public-preview-of-power-bi-rest-api-support-for-dax-queries/

However, we really need to get this out there as fully functioning product and I would argue it should go out under its own SDK. Power BI GUI and visuals are awesome but there are many clients that would want hook up their own custom look to the snappy data we get through Vertipaq.

DAX APIs .NET SDK should also be available not only for Power BI service but for SSAS too.

I worked just on such a project and we had to do quite a lot of alchemy through ADO.NET compiling all into a sql assembly building sql clr stored procs which then were picked up and turned into the end points.... it's a lot of unnecessary work. I bet many clients that need fast calculations especially for client facing apps they turn to Qlik where api data reads come natively.

A S's profile image Profile Picture

Maxime Basset on 10 Nov 2021 18:20:33

RE: REST API access to READ datasets

Really..?
When creating a REST API, reading is the first feature you have to create... I can't understand that...
Really need this

A S's profile image Profile Picture

Paula Duff on 27 Aug 2021 18:33:04

RE: REST API access to READ datasets

We are also doing a lot of transformation of data in Power BI which is then needed for other applications without having to duplicate these transformations again.

A S's profile image Profile Picture

Jennifer Gemelaris on 21 Jul 2021 18:40:12

RE: REST API access to READ datasets

I can write rows into the dataset but then cannot read them via the API?? No, just no.

Also, we are trying to solve a difficult customer requirement and the UI requirements are too complicated to build in PBI matrix/report/table but the dataset feature in PBI would work so great...if we could only retrieve the data view the UI....

A S's profile image Profile Picture

Tevett Goad on 21 Jun 2021 20:24:50

RE: REST API access to READ datasets

We use Power Bi for dashboards, but we also build dynamic excel spreadsheets off its data model. We want to transition the refreshing of these spreadsheets to our systems instead of a person doing it manually. Not being able to query the data model is presenting a considerable road block.

A S's profile image Profile Picture

Przemysław Baran on 17 Jun 2021 12:17:07

RE: REST API access to READ datasets

We are currently generating a solution to send data to PBI, but we also need a way to send some data back to the application. READ option in REST API is necessary to enable integrating PBI in Enterprise solutions.

A S's profile image Profile Picture

Luu Duong on 01 Jun 2021 17:57:55

RE: REST API access to READ datasets

We need this capability to save the dataset to JSON format for use in a .NET web application. The .NET application already embeds powerbi reports so it seems like natural transition to also getting the dataset for querying or other uses.

A S's profile image Profile Picture

Shaun Wilkinson on 20 Apr 2021 01:23:58

RE: REST API access to READ datasets

Like many others this limits what you can do within the API - It seems there is an ability there its just not being open to developers - please add this facility and have us developers make the most of PowerBI and not be restrained.

A S's profile image Profile Picture

Aslak Jonhaugen on 22 Feb 2021 07:44:49

RE: REST API access to READ datasets

I'm shocked that it's not possible to read a dataset in he REST-api! You have to fix this ASAP!