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
Need this feature to be available ASAP.
I am glad to see we broke the ice on this feature with this :
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.
When creating a REST API, reading is the first feature you have to create... I can't understand that...
Really need this
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.
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....
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.
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.
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.
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.
I'm shocked that it's not possible to read a dataset in he REST-api! You have to fix this ASAP!
Administrator on 9/7/2022 5:08:04 PM
Now available via the ExecuteQueries REST API - https://powerbi.microsoft.com/en-us/blog/announcing-general-availability-of-the-executequeries-rest-api/