Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ralf_hein
New Member

Publish App via REST API

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:

  1. Develop / Update Reports etc. in PBI Desktop
  2. Save under a common Name, e.g. "Reports.pbix" with all Parameters set to empty
  3. Import this "generic" pbix file into all PBI Workspaces via REST API
  4. Update/Individualise Parameters per Workspace via REST API
  5. 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!

7 REPLIES 7
pvuppala
Advocate II
Advocate II

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?

powerbi_jenhen
Resolver II
Resolver II

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

Srilakshmi_11
New Member

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?

v-micsh-msft
Employee
Employee

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

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.

Anonymous
Not applicable

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

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.