Power BI Automation With Semantic Link (Sandeep Pawar)

[@bossbalaynibilaybilat4083]

Thanks Sandeep... This is a pot of gold of Fabric cheatsheets! I learned a a lot.

[@joaorataoo]

Until two days ago I didn't know Semantic-Link existed. It's absolutely fabulous! Thank you very much for such valuable information.

[@notoriousft]

One of this channel's best sessions. Thanks a lot

[@HavensConsulting]

Glad you enjoyed it!

[@karthikkumar3854]

Thanks Sandeep & Reid

[@karthikkumar3854]

Hi Team, I am able to get the list of gateways using semantic link but not the gateway status. We are managing around 10 Gateway clusters & I would like to get the status as well. I see Powershell cmd option but do I have option get status details in the Notebook itself to load table directly to lakehouse & planning to trigger email if any of the gateway cluster not online

[@noahhadro8213]

Sandeep, is there a way to use notebooks or semantic link to back up and restore power bi semantic models? If yes can you point me to some documentation or show us how? Today I have to use powershell or ssms. Thanks.

[@noahhadro8213]

Does temperature reset each time the dataset is refreshed?

[@SandeepPawar1]

Yes, that's why I mentioned you would take a snapshot of the vertipaq before the refresh and track temp over a period of time.

[@MucahitKatirci]

[@noahhadro8213]

How can I use "Contains" in my filter for semantic link? I want to list workspaces that contain "Dataset" in the name? I tried something like this..... fabric.list_workspaces(filter= substringof('name', 'Dataset')).Name

[@SandeepPawar1]

df = fabric.list_workspaces() filtered_df = df[df['Display Name'].str.contains('Dataset', case=False, na=False)] Try this.