Forum Discussion

dax_powerbi's avatar
dax_powerbi
Frequent Visitor
2 years ago
Solved

Extract a GUID from a URL

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&dashbo...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    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.

     

danextian's avatar
danextian
Super User
2 years ago

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.