Dax code to combine bookmarks

Hi manasengineer ,

We can't use DAX to validate our URLS. But we can make the URL validation in Power Query.

Refer to

Solved: URL validation - Microsoft Fabric Community

You can use the Web.Contents function in Power Query to get the status code of a URL. If the status code is 200, then the URL exists, and you can navigate to it. Otherwise, you can show the bookmark. Here is a sample DAX code that uses the Web.Contents function to get the status code of a URL:

let
    url = "https://www.example.com",
    response = Web.Contents(url, [RelativePath="", Headers=[#"User-Agent"="Mozilla/5.0"]]),
    status = Value.Metadata(response)[Response.Status]
in
    status

In this example, we use the Web.Contents function to get the status code for the URL "https://www.example.com". Note that we also set a User-Agent header so that the web server knows that we are accessing the URL using the Mozilla Firefox browser. Finally, we use the Value.Metadata function to get the metadata of the response, and then use the Response.Status key to get the status code.

Note that if your URL requires authentication, you will need to provide authentication credentials. You can use the Options parameter of the Web.Contents function to provide authentication credentials.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.