Forum Discussion

vaalyushin's avatar
vaalyushin
Helper I
4 years ago

Upload pbix with python

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

 

@api
Nead Help

2 Replies

  • d_gosbell's avatar
    d_gosbell
    Super User
    4 years ago

    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)