topic Re: Uploading a PBIX file using the import API in Developer

Uploading a PBIX file using the import API

fgroenev — Thu, 15 Feb 2018 10:06:59 GMT

Hello,

I am stuck trying to programmatically upload a .pbix file using the import API, making use of the request-promise library which is imported as "rp" here.

I am currently trying the following (in Node.js), which results in HTTP error 400:

let url = 'https://api.powerbi.com/v1.0/myorg/groups/' + groupId + '/imports';
		
let options = {
	method: 'POST',
	headers: {
		'Content-Type': 'multipart/form-data',
		'authorization': 'Bearer ' + accessToken
	},
	body: fs.createReadStream(__dirname + '/Report.pbix'),
	url: 'https://api.powerbi.com/v1.0/myorg/groups/' + groupId + '/imports'
};

rp(options)
	.then(function (body) {
	console.log('success! ', body);
})
	.catch(function (err) {
	console.log('error', err);
});

I also haven't had any success uploading the file using postman, where I have tried it with and without having set the Content-Type header.

What could I be doing wrong? What headers are necessary to upload this file and make a proper request?

Re: Uploading a PBIX file using the import API

fgroenev — Thu, 15 Feb 2018 16:09:21 GMT

I figured out what I did wrong. Apparently you need a datasetDisplayName which is part of the url.

Therefore this problem can be solved by appending the datasetDisplayName field to the url like this:

url: 'https://api.powerbi.com/v1.0/myorg/groups/' + groupId + '/imports?datasetDisplayName=' + reportName

Re: Uploading a PBIX file using the import API

Anonymous — Fri, 14 Feb 2020 13:44:14 GMT

This is Python equivalant to upload a .pbix local file into PowerBI server

import requests
from requests_toolbelt.multipart.encoder import MultipartEncoder

groupId = "your workspace ID"
reportName = "reportName that you choose to appear on the server"
accessToken = "xx"

url = 'https://api.powerbi.com/v1.0/myorg/groups/' + groupId + '/imports?datasetDisplayName=' + reportName
headers = {
    'Content-Type': 'multipart/form-data',
    'authorization': 'Bearer ' + accessToken
}
file_location = '/xx.pbix'
# you need this dictionary to convert a binary file into form-data format
# None here means we skip the filename and file content is important 
files = {'value': (None, open(file_location, 'rb'), 'multipart/form-data')}

mp_encoder = MultipartEncoder(fields=files)

r = requests.post(
    url=url,
    data=mp_encoder,  # The MultipartEncoder is posted as data, don't use files=...!
    # The MultipartEncoder provides the content-type header with the boundary:
    headers=headers
)