topic Re: Not able to generate PDF via PowerBI API call in java in Developer

Not able to generate PDF via PowerBI API call in java

sharvan270 — Wed, 15 Sep 2021 12:53:50 GMT

Hi,

I was trying to generate PDF using API call in java code. I tried following API calls but getting empty PDF after exporting as File:

POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/ExportTo
From this api call, I get the export id.
To get the status of the exported file, used below API call:
GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/exports/{exportId}
Added while loop to wait until the status is 200 OK
Once status is 200, I have called below API call:
GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/exports/{exportId}/file
This api provides the File. Following code snipet I have used:

RestTemplate getReportRestTemplate = new RestTemplate();
HttpHeaders headers = new HttpHeaders();

headers.put("Content-Type", Arrays.asList("application/pdf"));
headers.put("Accept", Arrays.asList("application/*"));
headers.put("Authorization", Arrays.asList("Bearer " + accessToken));
// HTTP entity object - holds header and body
HttpEntity<String> reqEntity = new HttpEntity<> (headers);
ResponseEntity<String> response = getReportRestTemplate.exchange(urlStringBuilder.toString(), HttpMethod.GET, reqEntity, String.class);

Path file = Paths.get("D:\\test.pdf");
try (InputStream in = new ByteArrayInputStream(response.getBody().getBytes())) {
Files.copy(in, file);
}

Am I missing anthing here?

Re: Not able to generate PDF via PowerBI API call in java

lbendlin — Thu, 16 Sep 2021 01:04:04 GMT

Your while loop needs to check the "percentComplete" export status, not the HTTP 200. Only when percentComplete is 100 can you fetch the file.

Re: Not able to generate PDF via PowerBI API call in java

sharvan270 — Thu, 16 Sep 2021 04:40:16 GMT

There are only two responses mentioned in the API document https://docs.microsoft.com/en-us/rest/api/power-bi/reports/get-export-to-file-status-in-group

Re: Not able to generate PDF via PowerBI API call in java

lbendlin — Thu, 16 Sep 2021 11:57:14 GMT

You need to look inside the Export response

Re: Not able to generate PDF via PowerBI API call in java

sharvan270 — Fri, 17 Sep 2021 06:32:11 GMT

Verified with PercentComplate attribute of Export and even after that getting same issue.

Re: Not able to generate PDF via PowerBI API call in java

lbendlin — Fri, 17 Sep 2021 11:26:07 GMT

Did you wait for PercentComplete to reach 100?

Re: Not able to generate PDF via PowerBI API call in java

sharvan270 — Fri, 17 Sep 2021 14:06:15 GMT

Yes, I waited till 100 percentage then called next API call

Re: Not able to generate PDF via PowerBI API call in java

lbendlin — Fri, 17 Sep 2021 14:39:17 GMT

Can you try it in Powershell? The below works for me:

# Calls the Active Directory Authentication Library (ADAL) to authenticate against AAD function GetAuthToken { if(-not (Get-Module AzureRm.Profile)) { Import-Module AzureRm.Profile } $clientId = "<your client id>" $redirectUri = "urn:ietf:wg:oauth:2.0:oob" $resourceAppIdURI = "https://analysis.windows.net/powerbi/api" $authority = "https://login.microsoftonline.com/common/oauth2/authorize"; $authContext = New-Object "Microsoft.IdentityModel.Clients.ActiveDirectory.AuthenticationContext" -ArgumentList $authority $authResult = $authContext.AcquireToken($resourceAppIdURI, $clientId, $redirectUri, "Auto") return $authResult } # Get the auth token from AAD $token = GetAuthToken # Building Rest API header with authorization token $authHeader = @{ 'Content-Type'='application/json' 'Authorization'=$token.CreateAuthorizationHeader() } #Report details $groupsPath = "<workspace guid>" $reportID = "<report guid>" # 0. get page names - optional $uri = “https://api.powerbi.com/v1.0/myorg/groups/$groupsPath/reports/$reportID/pages" $Pages = Invoke-RestMethod -Uri $uri –Headers $authHeader –Method GET # 1. export request URI $uri = “https://api.powerbi.com/v1.0/myorg/groups/$groupsPath/reports/$reportID/ExportTo” $body = "{ format : `"PDF`” }" # how to define the pages? powerBIReportConfiguration:{pages:[{pageName:"<page 1 guid>"},{pageName:"page2 guid>"}]} # issue the export request $FileExport = Invoke-RestMethod -Uri $uri –Headers $authHeader –Method POST -body $body #save the ID - we need it later $exportId = $FileExport.id # 2. export request status URI $uri = "https://api.powerbi.com/v1.0/myorg/groups/$groupsPath/reports/$reportID/exports/$exportId" $percentComplete = 0 # repeat rendering status check until status is Succeeded while ($percentComplete -lt 100) { Start-Sleep -Seconds 30 $exportStatus = Invoke-RestMethod -Uri $uri –Headers $authHeader –Method GET $percentComplete = $exportStatus.percentComplete Write-Host $percentComplete } # 3. retrieve the rendered file $uri = "https://api.powerbi.com/v1.0/myorg/groups/$groupsPath/reports/$reportID/exports/$exportId/file" Invoke-RestMethod -Uri $uri –Headers $authHeader –Method GET -OutFile "test.pdf"