topic Re: Upload pbix with python in Report Server

Upload pbix with python

vaalyushin — Mon, 25 Jul 2022 14:31:54 GMT

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

Re: Upload pbix with python

d_gosbell — Tue, 26 Jul 2022 02:29:16 GMT

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)

Re: Upload pbix with python

Cylogus — Wed, 07 Jun 2023 13:19:56 GMT

This code works well?