Whether building reports in Power BI Desktop or in the web browser via the Power BI service, you have limited options to batch or streamline changes. Put another way; it’s tedious and slow to make many small changes to one or more Power BI reports. It’s also easy to make mistakes
When initially designing or building a report, this is not so much of a problem. Unless you’re using a template, you want to control report layout and formatting, yourself. However, certain changes can be little more than a waste of time. Some examples include:
- Replacing fields when there’s a broken reference due to i.e. renaming a model measure or column.
- Swapping one measure or column for another in the report
- Changing visual container styles, like background, border, and shadow/glow.
- Changing text or text styles across multiple visuals, pages, or reports.
- Changing chart formatting (like color) or properties (like edit interactions) across multiple visuals, pages, or reports.
Read on to see how you can make some of these changes in Python code using the semantic-link-labs library.