topic Publish App via REST API in Developer

Publish App via REST API

ralf_hein — Tue, 01 May 2018 21:09:56 GMT

We are running a potentially large number of individual reports (individualised via Parameters) that are made available to users as Apps. Basically, the reports are identical but the data content and some details are individual per workspace/app.

Our current workflow is like this:

Develop / Update Reports etc. in PBI Desktop
Save under a common Name, e.g. "Reports.pbix" with all Parameters set to empty
Import this "generic" pbix file into all PBI Workspaces via REST API
Update/Individualise Parameters per Workspace via REST API
Trigger data load into the newly imported dataset via REST API

Now, whats missing is a way to actually publish the updated app to the users. We always have to go manually via the web interface and click "Publish App" for each and every workspace.

We have tried to imitate the web interface json requests via scripting, but had no luck with this so far.

Is there any workaround or undocumented API for this?

Any idea or help is highly appreciated. Thank you!

Re: Publish App via REST API

v-micsh-msft — Wed, 02 May 2018 10:15:34 GMT

Thanks for the good idea.

But I am afraid currently it is not available for Power BI Embedded API to publish the App created in Power BI Service.

Take a look at what could be done through the Power BI Embedded through the article below:

https://docs.microsoft.com/en-us/power-bi/developer/overview-of-power-bi-rest-api

Besides, if you would like Power BI Embedded to be able to update App through API, then please rise it as an idea:

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards,

Michael

Re: Publish App via REST API

ralf_hein — Wed, 02 May 2018 10:35:23 GMT

Michael, thank you for the clarification!

There is actually already an idea that is pretty much identical listed here:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20468686-publish-app-via-rest-api

For the meantime, do you have any idea on how to handle this? We are speaking about >100 Apps, with updates and enhancements coming in every 2-3 weeks for the comming months. So doing the "publish" step manually really does not sound like an option.

Does maybe anyone know about some resources regarding scripting the PBI web UI? Think Greasemonkey, iMacros or similar.

Re: Publish App via REST API

Anonymous — Fri, 20 Sep 2019 15:40:21 GMT

@ralf_hein Did you ever find a solution to this? We're looking to do the same.

Re: Publish App via REST API

dibaSFP — Wed, 08 Jan 2020 10:02:40 GMT

We have automated this via Selenium (see selenium.dev) sripts for now. Works ok, we only have to do minor adjustments everytime MS changes the pbi web interface. This basically is screen scraping it and clicking the links to publish the apps.

Re: Publish App via REST API

Srilakshmi_11 — Tue, 24 Mar 2020 15:10:40 GMT

Hi,

We are also planning to automate the reports deployment. So could you please share some source how did you do this?

Have you used Java to call PBI rest services? Also used any batch automation to run this deployment?

Re: Publish App via REST API

powerbi_jenhen — Thu, 19 May 2022 22:43:11 GMT

This is now possible, well to update the published app, not to initially publish the app: Solved: Re: Power BI Rest API to Update Workspace App - Microsoft Power BI Community

Re: Publish App via REST API

pvuppala — Tue, 05 Dec 2023 16:06:34 GMT

Has anyone tried to get this API working to Update or Publish the app ? I'm curious if it only works for Premium since it uses Deployment pipelines?