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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
msalerno
New Member

How to Update a Report theme via Power BI REST APIs

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!

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

View solution in original post

5 REPLIES 5
benjos23
Helper I
Helper I

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.

lbendlin
Super User
Super User

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

lbendlin
Super User
Super User

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.

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!

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. 

 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.