Help publishing PBIX files using REST API and service principal profile

Anonymous — Thu, 14 Jul 2022 00:05:41 GMT

I am developing a multi-tenant application. I am managing the tenants using service principal profiles.

each tenant has his own service principal profile.

The final step of the pipeline is to deploy the PBIX to the workspace on the client tenant.

I stored the PBIX file in a blob storage.

I want to publish this PBIX to a PBI worksapce using the REST API.

How can I do it? I am using PPU.

I followed this documantion and noticed that in order to publish a PBIX between 1GB-10GB I need premium capacity.

"To import large Power BI .pbix files that are between 1 GB and 10 GB in size, see Create Temporary Upload Location In Group. This is only supported for Premium capacity workspaces.

Under the assumption that my PBIX will be lager then 1GB, what other options do I have to import large .pbix files?

if it is not possible using PPU, Can I publish PBIX files smaller then 1GB which stored on a blob?

any examples? I review the documantion but I pretty uch lost...

I am adding the python function that I wrote.

Thank you, Tal

def PostPBIXInWorkspace(WorkspaceID,token,DatasetDisplayName): url = f'https://api.powerbi.com/v1.0/myorg/groups/{WorkspaceID}/imports?datasetDisplayName={DatasetDisplayName}' fileUrl='...blob url...' headers = {"Authorization": f"Bearer {token}"} payload = { "fileUrl": fileUrl } response = requests.request("POST", url, headers=headers, data=payload) response = json.loads(response.txt) print(response) return (response) return (response)

Re: Help publishing PBIX files using REST API and service principal profile

lbendlin — Sat, 16 Jul 2022 23:38:18 GMT

On a premium capacity there is a similar limit (10GB) that can be worked around by using incremental refresh and bootstrapping partitions. Is that something you could consider?

topic Help publishing PBIX files using REST API and service principal profile in Developer

Help publishing PBIX files using REST API and service principal profile

Re: Help publishing PBIX files using REST API and service principal profile