topic Error: MultipartRequestBodyParseError in Developer

Error: MultipartRequestBodyParseError

LukaP — Mon, 12 Jun 2023 07:29:00 GMT

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)

Re: Error: MultipartRequestBodyParseError

Anonymous — Wed, 14 Jun 2023 02:18:35 GMT

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

Re: Error: MultipartRequestBodyParseError

LukaP — Wed, 14 Jun 2023 06:40:41 GMT

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