Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
Status: Completed
Comments
Shaun_Wilkinson
New Member
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.
luu_duong
New Member
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.
przemyslaw_bara
New Member
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.
tevett
New Member
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.
jgemelaris
New Member
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....
PDuff
New Member
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.
maximebasset
New Member
Really..? When creating a REST API, reading is the first feature you have to create... I can't understand that... Really need this
nick_chobotar
New Member
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.
simontaylor
Microsoft Employee

Need this feature to be available ASAP.

nishalit
New Member