Hey @luanlopes ,
This error typically indicates that the Power BI REST API is receiving a missing or incorrectly formatted parameter but unfortunately, the message doesn’t specify which one. Here's a thorough breakdown of possible issues and how to resolve them.
What Might Be Causing the Issue
1. fileUrl Must Be the sasUri (Not url)
Power BI's createTemporaryUploadLocation response returns an object that includes sasUri and fileUploadState. You must use the sasUri in the import call:
const uploadUrl = tempLocationResponse.data.sasUri;
You're currently using tempLocationResponse.data.url, which is likely incorrect or empty hence the illegal input: '' error.
2. Body Format Must Match Expected Schema
When calling the import API with a fileUrl, your body must include:
{
"fileUrl": "<SAS URL>",
"datasetDisplayName": "MyDataset",
"nameConflict": "Overwrite"
}But in your current code, you're passing datasetDisplayName and nameConflict as query parameters, not in the body.
Fix:
const importApiUrl = `${POWERBI_API_BASE_URL}/groups/${GROUP_ID}/imports`;
const bodyPost = {
fileUrl: uploadUrl,
datasetDisplayName: "MyDataset",
nameConflict: "Overwrite"
};
const importResponse = await axios.post(importApiUrl, bodyPost, { headers });
Updated Code Fixes
// Get temporary upload URL
const tempLocationResponse = await axios.post(TEMP_UPLOAD_LOCATION_URL, {}, { headers });
const uploadUrl = tempLocationResponse.data.sasUri; // use sasUri instead of url
// Upload PBIX file
await axios.put(uploadUrl, fileBuffer, {
headers: {
'Content-Type': 'application/octet-stream',
'x-ms-blob-type': 'BlockBlob'
},
maxContentLength: Infinity,
maxBodyLength: Infinity,
});
// Call Import API
const importApiUrl = `${POWERBI_API_BASE_URL}/groups/${GROUP_ID}/imports`;
const bodyPost = {
fileUrl: uploadUrl,
datasetDisplayName: 'MyDataset',
nameConflict: 'Overwrite'
};
const importResponse = await axios.post(importApiUrl, bodyPost, { headers });
console.log('Import successful:', importResponse.data);
In Short:
Using url instead of sasUri (Replace tempLocationResponse.data.url with .sasUri)
Passing parameters in URL (Pass datasetDisplayName and nameConflict in the request body)
Empty string error (Likely due to fileUrl being '' or malformed)
If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.
Best Regards,
Nasif Azam
