Skip to main content

Power BI

Needs Votes

Programmatic way ( via REST API) to get the pure data of a dataset in POWER BI Service.

Vote (30) Share
vivek jain's profile image

vivek jain on 31 Jan 2018 14:26:17

Intention is to receive the data insides of the report so that I can do an automated sanity of report data. Report PBIX file export is not of use to me as my utility code cannot read data from it
As of now there is no way to create automated testing to verify the health of reports that they are running fine with correct data .
Also , we can have any REST api for export to .csv/. xml , this might also work for automation test building.

Comments (3)
vivek jain's profile image Profile Picture

Daniel on 05 Jul 2020 23:33:25

RE: Programmatic way ( via REST API) to get the pure data of a dataset in POWER BI Service.

I also need that functionality. This is the only feature missing, we can't move our BI environment to MS platform because of that. I have a number of scheduled reports that are automatically extracted to XLSX or CSV file and then send to clients as an attached file. Please implement that feature if you want to earn more money Microsoft!!!

vivek jain's profile image Profile Picture

Paul C on 05 Jul 2020 23:11:57

RE: Programmatic way ( via REST API) to get the pure data of a dataset in POWER BI Service.

Agree this could be useful for our automation testing as mentioned.

vivek jain's profile image Profile Picture

Howard D on 05 Jul 2020 23:11:56

RE: Programmatic way ( via REST API) to get the pure data of a dataset in POWER BI Service.

It is necessary for critical systems to have an automated way to retrieve and validate raw report data. I would consider this an essential feature in any cloud reporting platform