Creative way to use Sempy to update a Power BI report definition

Need to do a bulk change of something in your Power BI report? The new Power BI report format enables some slick automations. Patrick uses Sempy to get this done!

What is semantic link?

Items - Get Item Definition

Items - Update Item Definition


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #report #GuyInACube

[jatinsrivastava]

I have the similar requirement but this is how I achieved it :

1) I stored the image in a shared SharePoint folder, copied the link of the image.

2) created a table into my database having one column which is a varchar type.

3) The link which I copied, I used a small line of python code to change the link into Binary format and then inserted it into the created table.

4) Used a new card visual and took the column in the image url section and removed the other formatting, background color etc..

Next time if the user wants to change the logo he just needs to upload the image in the SharePoint folder copy the link, change the datatype, and update the table.

This process helped me not only to change the logo, theme color of the report as well.

[norawhite]

Oh just in time! Boss wanted to change the logo to one with transparent background and I was losing my mind 😭 THANK

[Nalaka-Wanniarachchi]

Nice one with Sempy.I suggest to change the video title as 'Bulk Update reports with Sempy' in order to find easily.

[joeseroski]

Could this be used to update conditional formatting?

[lopypop]

Can Sempy be used to update apps after publishing?

[sajfaml]

is there any way how to bulk update the m code (power query) ? thx

[IAMJB]

Can this same api be used to query reports data to pull in?

For instance let’s say I have report “tales” in workspace “great” can I pull in the data from that report to use?

[FinazSodagar]

there is no videos about forcasting using dax in powerbi...!! now a days forcasting is very helpful feture.... hey GUY IN CUBE can you please upload forcating

[bryanrock]

I'm wondering if I can do something like this to update all the column names on all my thin reports. We're eventually going to be switching to DirectLake, so I'm going to need to replace any spaces with underscores.

[Fernando_Calero]

@PatrickDBA how comfortable do you feel working with Python after so many years being a SQL guy?

[BhupendraPatel]

Q: this updates in workspace, how does that get to git ? If I have updates from git to workspace…