Uploading a PBIX file using the import API in nodejs

[raviShekhar404]

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

[raviShekhar404]

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)

[raviShekhar404 · Accepted solution]

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