topic Re: Get File Of Export To File In Group - NodeJS / React in Developer

Get File Of Export To File In Group - NodeJS / React

trpeel — Tue, 16 Apr 2024 04:24:58 GMT

Hello. I am trying to figure out how to stream/download the exported PDF file from a Power BI API Export call. I'm using a NodeJS backend with a React frontend. Here's what I'm trying to do in the backend:

const queryResults = await fetch(`https://api.powerbi.com/v1.0/myorg/groups/${workspaceId}/reports/${reportId}/exports/${exportId}/file`, { method: 'GET', headers: { 'content-type': 'application/pdf', authorization: `Bearer ${(await getAccessToken()).accessToken}` } }); return queryResults;

For reference: https://learn.microsoft.com/en-us/rest/api/power-bi/reports/get-file-of-export-to-file-in-group

All I get is a JSON response of { size: 0, timeout: 0}. I've found some C# samples online for streaming the PDF file back to the browser, but nothing for NodeJS. Any help would be appreciated.

Thanks.

Re: Get File Of Export To File In Group - NodeJS / React

Anonymous — Wed, 17 Apr 2024 08:42:19 GMT

Hi @trpeel ,

It sounds like you are trying to download a PDF file that has been exported from a Power BI report using the Power BI API. However, it return size 0. The possible reason is the API call is not correctly authenticated. Please update the code as below and check if it can return the expected result...

Best Regards

Re: Get File Of Export To File In Group - NodeJS / React

trpeel — Wed, 17 Apr 2024 17:25:57 GMT

Thank you very much. The response.buffer was the part I was missing. I appreciate the help.