Skip to main content

Power BI

Needs Votes

REST API access to READ datasets

Vote (424) 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

Comments (19)
A S's profile image Profile Picture

8bb0d1c4 bce7-4e41-ac4f-b6d89901e852 on 31 Aug 2020 17:28:00

RE: REST API access to READ datasets

Please make this feature available a.s.a.p. so that we need not create a separate REST API just for fetching the same data from a different source. This will make the lives of developers and architects a little less complicated.

A S's profile image Profile Picture

67c69a25 01a8-4dc5-999d-7fb255ade5df on 06 Jul 2020 00:12:17

RE: REST API access to READ datasets

How on earth is this still not possible? Really? What the reason? We really thinking about moving forward from Power BI. Read datasets are MUST !!! Please implement it ASAP!!!!

A S's profile image Profile Picture

9464abe8 8d27-49c8-a993-4de1d35d58ba on 06 Jul 2020 00:12:14

RE: REST API access to READ datasets

How on earth is this still not possible. Pulling data via API seems like the very first thing you would ever want to do.

A S's profile image Profile Picture

9749a29c c710-46fb-b5e8-b6f615fd5a9f on 06 Jul 2020 00:11:02

RE: REST API access to READ datasets

'+

A S's profile image Profile Picture

0090a0ed ae34-4d46-b64a-018de1ad9851 on 06 Jul 2020 00:06:50

RE: REST API access to READ datasets

I am flabbergasted that this is not a feature! who wouldn't want to retrieve data that has been massaged and filtered in a nice report programmatically via the API to use?
I mean, seriously?

A S's profile image Profile Picture

90ec4c2f 18eb-4976-aad8-3a66ef315f92 on 06 Jul 2020 00:03:00

RE: REST API access to READ datasets

Please add this functionality, being able to have a sturdy data model in Power BI is amazing but not being able to use the data to make complementary processes is such a huge disadvantage.

A S's profile image Profile Picture

70db70d3 12fa-49cd-9e4c-2cc592da498c on 06 Jul 2020 00:02:26

RE: REST API access to READ datasets

Once you have processed data in the integrated model from different sources, for instance, to elaborate KPIs, it would be very desirable to access Power BI Service to get them through a REST API.

A S's profile image Profile Picture

6cf04b4a 8b56-41b6-9ce8-710d2fdb3c3c on 05 Jul 2020 23:58:09

RE: REST API access to READ datasets

This is pretty important, if you want to embed PowerBI numbers in your presentation or somewhere else.

A S's profile image Profile Picture

7aa63f15 5b88-ea11-a812-000d3a579c39 on 05 Jul 2020 23:48:04

RE: REST API access to READ datasets

This feature is extremely important, and like other people I was shocked to find out that I can't connect to PowerBI dataset suing Oauth token from javascript API or .Net client to read the data from it using DAX.
If Excel and PowerBI desktop can connect to any powerBI dataset it should be very easy to allow any client to connect to it and query it.

A S's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:33:01

RE: REST API access to READ datasets

What happened to my earlier comments?!

I had said something along the lines of, since we use pbi to elegantly query multiple sources and combine to produce new tables, it is crazy to repeat these same transformations in other tools against the same sources to find the same results. This will lead enterprise users to skip powerbi and instead only use those other tools, perhaps using powerbi later as a viewer but we'll definitely avoiding 'creating' any irretrievable value in powerbi.

API access to read datasets is a no brainer and enables our data to become programmatically accessible and actionable rather than just shiny visuals. If necessary limit the API in terms of rows or frequency of queries.

Our data wants to be free! Our actions want to be automatic! Our humans don't want to be obligated to micromanage all actions that can be influenced by the data we've fed powerbi.

Similarly we would like to read dashboard tiles/kpi values. If that were available we could ensure each actionable scenario was captured on a pinned kpi for 'alerts's or complex flow actions.