Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
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
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
)
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
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
17 | |
11 | |
5 | |
4 | |
3 |