Extract a GUID from a URL

[dax_powerbi]

How can i extract the GUID from this URL into a new column:
https://abc.xyz.ca/home.aspx?sitemappath=Workplace%7cMyWork%7cnav_dashboards&dashboardId=%7bx88fbece-7653-e521-8e77-002056b805fe%7d&dashboardType=1031&pagemode=iframe

[danextian · Accepted solution]

Hi @dax_powerbi ,

If you are trying to extact the dashboardID, try this as a custom column in Power Query:

Text.BetweenDelimiters([Column1], "%", "%", 2, 0)

If you're trying to extract the webpage itself, it is not accessible from our end.

[dax_powerbi]

Awesome! Thank you @danextian