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
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.
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!!!!
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.
RE: REST API access to READ datasets
'+
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?
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.
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.
RE: REST API access to READ datasets
This is pretty important, if you want to embed PowerBI numbers in your presentation or somewhere else.
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.
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.