topic Re: Uploading a PBIX file using the import API in nodejs in Developer

Uploading a PBIX file using the import API in nodejs

raviShekhar404 — Fri, 15 Dec 2023 05:37:40 GMT

Hi folks,

I am facing issue while uploading a PBIX file from local storage using import API. Code is in nodejs. Please find snipshot below

let options = { method: 'POST', headers: { 'Content-Type': 'multipart/form-data', 'authorization': 'Bearer ' + authToken }, body: fs.createReadStream(filePathOnLocal + 'report.pbix'), url: `https://api.powerbi.com/v1.0/myorg/groups/${group_id}/imports?datasetDisplayName=report.pbix&nameConflict=CreateOrOverwrite` }; const result = await axios.request(options)

It is giving me error

I had found same code in other post, but not sure why I am facing this issue.

Also for verify if file is correct or not, I have called PBI API directly from Postman with same file and it successfully upload the file on desired group. Only for code it is failing

Re: Uploading a PBIX file using the import API in nodejs

raviShekhar404 — Mon, 18 Dec 2023 10:45:44 GMT

Issue fixed, from one of the post I come to know that Content-Lenght is required to append in headers.

Attaching link of that post
'Post in Group' API using Nodejs - Microsoft Fabric Community

Happy sharing

Re: Uploading a PBIX file using the import API in nodejs

raviShekhar404 — Mon, 18 Dec 2023 10:48:39 GMT

One more observation, with axios only we have to do these changes. Because I have tried with request library(depricated in nodejs) also and it works fine.

let options:any = {

method: 'POST',

headers: {

'authorization': 'Bearer ' + authToken

data:{

"file":{"value":fs.createReadStream(filePath),"options":{"filename":"report.pbix","contentType":null}},

url: url

};

const result = await request(options)

console.log(result)