Error: MultipartRequestBodyParseError

[LukaP]

Hello, so i am trying to upload files using POST Import API request. So far I have successfully uploaded a PBIX file to my workspace with the API call, but when i try and upload an XLSX file with the same function i get

{"error":{"code":"MultipartRequestBodyParseError","pbi.error":{"code":"MultipartRequestBodyParseError","parameters":{},"details":[]}}}

The function that i use to upload the file is:

def import_file(token,datasetDisplayName,file):
    url = f"https://api.powerbi.com/v1.0/myorg/imports?datasetDisplayName={datasetDisplayName}"
    header = {
        "Authorization": f"Bearer {token}",
        "Content-type": "multipart/form-data"
    }
    payload = {
        "filePath": file,
    }
    r = requests.post(url, headers=header, files=payload)
    response = r
    print(response)
    print(response.text)

file_path = "test_file.xlsx"
file_contents = open("test_file.xlsx", "rb")
import_file(token,"Melbourne.xlsx", file_contents)

[Anonymous]

Hi @LukaP ,

Where did the file hosts? If it was store in sharepoint or onedrive online, please set the context-type to 'application/json'.
If you are work with a local file, I'd like to suggest you to use the absolute path instead to relative path to help requests correctly find the pending upload files.

Imports - Post Import - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Regards,

Xiaoxin Sheng

[LukaP]

Hello,

The files are on my local machine; i have tried using the aboslute path but the result is the same, I still get the "MultipartRequestBodyParseError".

I have also tried reading the entire file and trying to upload that variable, however nothing changed. I also tried switching content-type to "json" just to see if it works and then it gave me response code 400, without any errors this time

Honestly, at this point i have no idea what is going wrong