arsh1's avatar
arsh1
New Member
11 years ago
Status:
Completed

REST API access to READ datasets

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
power bi

31 Comments

  • Jonathan_P's avatar
    Jonathan_P
    Icon for Helper II rankHelper II
    6 years ago
    This is required as we want to pull data from a custom registered client application.
  • Arikm's avatar
    Arikm
    Regular Visitor
    6 years ago
    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
  • jorge_quintero1's avatar
    jorge_quintero1
    New Member
    6 years ago
    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.
  • simon_loughnan1's avatar
    simon_loughnan1
    New Member
    6 years ago
    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.
  • james_nowlan's avatar
    james_nowlan
    New Member
    6 years ago
    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.
  • pbiideas1's avatar
    pbiideas1
    New Member
    6 years ago
    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.

Recent ideas