topic How to Update a Report theme via Power BI REST APIs in Developer

How to Update a Report theme via Power BI REST APIs

msalerno — Fri, 06 Aug 2021 19:06:26 GMT

tldr; How can I update report theme via REST API?

I have a set of reports residing in muliple workspaces. Each workspace has a custom theme for the reports (set in Power BI Desktop manually). As part of my new CI/CD process, I would like to automate publishing PBIX files to each worksapces and set the appropriate theme. I do not see a way to set/update report themes in the REST API... maybe I am missing it...? Halp meh!

Thanks!

Re: How to Update a Report theme via Power BI REST APIs

lbendlin — Sun, 08 Aug 2021 21:16:38 GMT

You can't do that, but you can upload reports/datasets into workspaces via the API. Apply the theme to a local pbix and then upload that.

Re: How to Update a Report theme via Power BI REST APIs

msalerno — Mon, 09 Aug 2021 12:14:25 GMT

Hmm... that is not helpful from an automation perspective. If I have 10 reports and 100 customers, each with different themes, then I have to apply a theme 1,000 times and upload to their customer workspace before updating their customer app.

Re: How to Update a Report theme via Power BI REST APIs

lbendlin — Mon, 09 Aug 2021 17:03:37 GMT

why not helpful? Let the automation tool do its job, even if it means 1000 loops.

Re: How to Update a Report theme via Power BI REST APIs

LoyosBI_Florian — Fri, 12 Apr 2024 11:21:13 GMT

I also need a solution for setting up the same report in different workspaces with different themes. As this should be part of a continuous deployment process, changing the theme manually in desktop is not an option.

Therefore I would like to know if there still no solution for this via the API?

Another way I hoped would work is doing it by automatically changing the code of the new PBIP format, but it seems as in Preview, changes outside of PBI Desktop are not recognized.

A third option would be to use the git integration. However it would be neccessary that all theme-related code of a report would be stored in a separate file in the PBIP folder, that would make it possible to ignore this file in the deployment process. Currently this also seems to be not possible.

It would be great if anyone has other ides how to achieve an automatic theme update in the current environment. Thank you!

Re: How to Update a Report theme via Power BI REST APIs

benjos23 — Tue, 17 Sep 2024 07:54:46 GMT

Is there really no solution for this problem? It seems to me that this is still an important feature for automating the deployment of reports.