Download Power BI dashboard report in Java

[kalyanbl]

Hi, folks,

I work with a data scientist who uses Power BI to publish reports (essentially just a grid of text fields) on a web dashboard. For some of the reports I need to automate some actions, so I click 'Export data', download the report as a .csv file, then parse the CSV into a Java (Spring Boot) application which then automates the required tasks. Is it possible to get my Java application to directly download the CSV from Power BI, without me having to open it in a browser and export it?

I've been looking at the Rest API, but this seems to be primarily for inserting data into a realtime report, rather than exporting data out of it. I'm also trying to use the Satalyst wrapper (https://github.com/satalyst/powerbi-rest-java) but I suspect it might be out of date as I get an exception when trying to connect:

com.microsoft.aad.adal4j.AuthenticationException: {"error_description":"AADSTS90019: No tenant-identifying information found in either the request or implied by any provided credentials"}


Thank you
kalyan bl
http://bit.ly/2qJnhu8

[coder777]

Is it possible to get my Java application to directly download the CSV from Power BI, without me having to open it in a browser and export it?

Of course it is possible but the server must be prepared for such a request.

I suspect it might be out of date as I get an exception when trying to connect:

Actually it sounds as if the server needs some kind of authentication but you do not provide it.