Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi! I have Power BI Report Server May 2022 and i try to upload pbix-file use api. I write this code:
from asyncio.windows_events import NULL
from requests import request
import requests
from requests_toolbelt.multipart.encoder import MultipartEncoder
import json
from requests_ntlm import HttpNtlmAuth
from urllib3.exceptions import InsecureRequestWarning
from urllib3 import disable_warnings
disable_warnings(InsecureRequestWarning)
urlpbirs = "https://pbirs.ontoso.com/reports/api/v2.0/PowerBIReports"
file = open("testapi.pbix", "rb")
file_location = "testapi.pbix"
files = {'value': (None, open(file_location,
'rb'), 'multipart/form-data')}
mp_encoder = MultipartEncoder(fields=files)
headers = {
'accept': 'application/json',
# Already added when you pass json= but not when you pass data=
# 'Content-Type': 'application/json',
}
json_data = {
'Name': 'test',
'Description': 'test api with python',
'Type': 'PowerBIReport',
'Hidden': False,
'IsFavorite': False,
'ContentType': NULL,
'Content': '',
'HasDataSources': True,
'Path': '/BI Test'
}
r = requests.post(url=urlpbirs, data=mp_encoder, auth=HttpNtlmAuth(
'user', 'pass'), verify=False, headers=headers, json=json_data)
But it doesn't work
I'm pretty sure you need to use the CatalogItems endpoint to upload reports.
eg.
from asyncio.windows_events import NULL
from requests import request
import requests
import base64
import json
from requests_negotiate_sspi import HttpNegotiateAuth
from urllib3.exceptions import InsecureRequestWarning
from urllib3 import disable_warnings
disable_warnings(InsecureRequestWarning)
urlpbirs = "http://localhost/reports/api/v2.0/CatalogItems"
file = "C:/temp/test.pbix"
file_text = open(file, 'rb')
file_read = file_text.read()
file_encode = base64.b64encode(file_read).decode('utf-8')
headers = {
'accept': 'application/json',
'Content-Type': 'application/json',
}
json_data = {
'Name': 'BI Test 2',
'@odata.type': '#Model.PowerBIReport',
'ContentType': '',
'Content': file_encode,
'Path': '/BI Test 2'
}
r = requests.post(url=urlpbirs, auth=HttpNegotiateAuth(), verify=False, headers=headers, json=json_data)
print(r)
This code works well?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
5 | |
4 | |
3 | |
3 |
User | Count |
---|---|
14 | |
9 | |
7 | |
3 | |
3 |