topic Re: Rest API Export Report In Group with response code 200 but no PBIX file in Developer

Rest API Export Report In Group with response code 200 but no PBIX file

Anonymous — Tue, 22 Sep 2020 15:52:08 GMT

Hello,

I am using the Export Report In Group API to extract the pbix file of a report. After indicating the group ID and the report ID I get back the the 200 as response code with just a non human readable JSON file in the body.

Did something go wrong with the extraction or is there a use to such JSON file to obtain the pbix file? If there is, how could that be done?

Re: Rest API Export Report In Group with response code 200 but no PBIX file

lbendlin — Tue, 22 Sep 2020 22:08:25 GMT

That's not a JSON file, it's a ZIP file with a .pbix extension. You are supposed to pipe the output of the call into a local file, for example via curl -o <file> . Can't test that part in the sandbox.

Re: Rest API Export Report In Group with response code 200 but no PBIX file

Anonymous — Wed, 23 Sep 2020 10:22:36 GMT

I was indeed using the sandbox. Can you please indicate to me another approach on how to use the API to extract the pbix file?

Re: Rest API Export Report In Group with response code 200 but no PBIX file

lbendlin — Wed, 23 Sep 2020 11:06:49 GMT

What's your weapon of choice? Is curl enough, do you want to do this via Powershell or maybe Power Automate?