Hi @BhumitraSharma,
I’ve prepared an example script that you can use to test this solution. I’ll share it below:
#!/bin/bash
# ===============================
# Power BI PBIX Upload Using CURL (macOS/Linux)
# Author: Adapted for Luan Lopes
# ===============================
# Requirements: curl
# ===============================
# === CONFIGURATION ===
PBIX_FILE="your_pbix_file_path"
SAS_URL="your_sas_url"
# Check if file exists
if [ ! -f "$PBIX_FILE" ]; then
echo "❌ PBIX file not found at: $PBIX_FILE"
exit 1
fi
# Upload the file using PUT
echo "⏫ Uploading PBIX using curl PUT..."
curl -X PUT \
-T "$PBIX_FILE" \
-H "x-ms-blob-type: BlockBlob" \
-H "Content-Type: application/octet-stream" \
"$SAS_URL"
if [ $? -eq 0 ]; then
echo "✅ Upload completed successfully!"
else
echo "❌ Upload failed!"
exit 1
fi
After uploading the file, use the following endpoint to import it:
POST https://api.powerbi.com/v1.0/myorg/groups/{groupID}/imports?datasetDisplayName=Taxboard ICMS - Dexco.pbix&nameConflict=Overwrite
Make sure to replace datasetDisplayName with the actual .pbix file name (e.g., your_pbix_file.pbix) and ensure nameConflict=Overwrite is set to avoid conflicts.
Let me know if you need anything else!
Example:
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
Proud to be a Super User! |  |
Hey @luanlopes ,
Thanks for the detailed. You're right your url is the correct SAS URL. They’ve renamed sasUri to url in the latest API). The issue is likely with how you're passing parameters.
Try this minimal fix:
const importApiUrl = `${POWERBI_API_BASE_URL}/groups/${GROUP_ID}/imports`;
const bodyPost = {
fileUrl: uploadUrl, // from tempLocationResponse.data.url
datasetDisplayName: "MyDataset",
nameConflict: "Overwrite"
};
const importResponse = await axios.post(importApiUrl, bodyPost, {
headers: {
...headers,
'Content-Type': 'application/json' // ensure this is set for POST body
}
});Don’t use query params for datasetDisplayName or nameConflict.
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
Proud to be a Super User! | |
Helpful resources
Power BI Dataviz World Championships
Vote for your favorite vizzies from the Power BI World Championship submissions!
Join our Community Sticker Challenge 2026
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Power BI Monthly Update - January 2026
Check out the January 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
