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!
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.
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.