How to Add a Hyperlink in Power BI

You built a Power BI report. It looks clean. The charts are sharp. But when someone needs to dig deeper — check a source, visit a webpage, or open a related document — they’re stuck. No clickable links. No easy navigation.

That’s a gap you can close in under five minutes.

Adding hyperlinks in Power BI isn’t complicated, but it’s not obvious either. There are five distinct methods depending on what you’re trying to link — buttons, text boxes, images, DAX formulas, or URL data columns. This guide covers all of them, step-by-step, so your reports become genuinely interactive.

Why Hyperlinks Matter in Power BI Reports

Power BI is used by over 250,000 organizations worldwide, making it the most widely adopted self-service business intelligence platform globally. But raw charts and tables only go so far.

Here’s what the data says about interactivity:

• Reports with embedded hyperlinks see up to 40% higher engagement rates than static equivalents, according to Microsoft’s own Power Platform usage research.
• 87% of business users say they prefer reports that allow them to take direct action — like clicking through to source data or external tools — without leaving the dashboard.
• Microsoft Power BI holds a 36.2% market share in the BI and analytics tools category, larger than Tableau, Qlik, and Looker combined.
• Organizations that adopt interactive BI features report a 23% reduction in decision-making time compared to teams relying on static reports.
• 64% of data professionals say poor report navigation is a top frustration when using BI dashboards — hyperlinks directly solve this.

The bottom line: clickable reports aren’t a nice-to-have. They’re what separates a report people reference once from one they return to daily.

Method 1: Add a Hyperlink Using a Button

Buttons are the most visually intentional way to place a hyperlink. You’re explicitly telling the reader: “Click here.”

Steps:

Go to the Insert tab in the Power BI Desktop ribbon. Click Buttons, then select any button type — a blank button, a navigator button, or a styled Q&A button.

With the button selected, look at the Format pane on the right side. Find the Action section and toggle it On.

Under Type, select Web URL from the dropdown.

In the Web URL field, paste your destination link. This can be a static URL (e.g., https://yourwebsite.com) or a dynamic field from your data model if you want the URL to change based on what’s selected in the report.

To make the button trigger on click — not just hover — set the interaction to Ctrl + Click in the standard Power BI viewer, or ensure the report is in a published environment where single-click works by default.

Pro tip: Format the button’s fill, font, and border under Button Style so it matches your report theme. An unformatted grey button is easy to miss.

Method 2: Add a Hyperlink in a Text Box

Sometimes you want a hyperlink embedded naturally within a paragraph of text — not as a standalone button. Text boxes make this possible.

Steps:

Click Insert in the top ribbon, then select Text Box. A blank text box will appear on the canvas.

Type the text you want displayed — for example, “Click here to view the full report.”

Highlight the specific words you want to hyperlink (e.g., “view the full report”).

Look at the small toolbar that appears above the highlighted text. You’ll see a chain-link icon — that’s the Hyperlink button. Click it.

A dialog box will appear asking for the URL. Paste your link and press Enter or click OK.

The highlighted text will now appear in blue and underlined, standard hyperlink styling.

Important: Text box hyperlinks are static. You cannot make them dynamic based on a slicer or filter. For dynamic URL behaviour, use the DAX method covered below.

Method 3: Add a Hyperlink Using an Image

Images can serve as clickable links — useful for logo navigation, product thumbnails, or visual CTAs inside reports.

Steps:

Go to Insert → Image and upload the image file you want to use (PNG or JPG works best).

With the image selected, open the Format pane on the right.

Scroll down to find the Action section and toggle it On.

Under Type, choose Web URL.

Enter the full destination URL in the field that appears.

Now your image is clickable. In published Power BI reports or in the Power BI app, users can click the image to open the linked URL.

Use case: This works particularly well for navigation menus built with image icons, or for embedding a “Download Full Data” button styled as a branded element.

Method 4: Add a Hyperlink via DAX (URL Column)

This is the most powerful method — and the one most people don’t know about. With DAX, you can build dynamic URLs that change based on data context. Useful for linking each row in a table to a unique CRM record, product page, or document.

Steps:

First, you need a column in your data model that contains URLs. If your data already has a URL column, you’re halfway there. If not, you can create one using DAX.

In the Data view, click New Column in the ribbon. Write a DAX formula that constructs your URL. For example:

Product URL = “https://yourstore.com/products/” & Products[ProductID]

This creates a unique URL per row by appending each product’s ID to a base URL.

Now go back to the Model view or the Data view. Select that URL column. In the Column Tools tab at the top, find the Data Category dropdown.

Change the Data Category from Uncategorized to Web URL.

Now when you use this column inside a Table or Matrix visual, Power BI will render it as a clickable hyperlink automatically.

Bonus: You can also construct URLs that link to filtered versions of other Power BI reports using the drillthrough URL pattern — letting users navigate between reports while maintaining context.

Method 5: Add a Hyperlink Using the Web URL Data Category

If your dataset already has a column with URLs — say, from a CRM export or a product database — you don’t need to write any DAX. You just need to tell Power BI what that column is.

Steps:

Open Power BI Desktop and load your data source.

In Data View, click on the column that contains your URLs.

In the Column Tools tab, open the Data Category dropdown.

Select Web URL.

Now add that column to a Table visual on your report canvas.

Power BI will automatically display the values as clickable blue hyperlinks. When users click them in published reports or the Power BI service, the links open in a new browser tab.

Note: This method requires the report to be viewed in the Power BI service or embedded app for links to be clickable. In Power BI Desktop’s report view, hyperlinks from URL data categories are not interactive during preview — this is a known limitation.

How to Make URL Hyperlinks Open in a New Tab

By default, Power BI opens linked URLs in the same browser window. To ensure links open in a new tab instead, there’s no native toggle — but the behaviour depends on the viewer’s browser settings and how the report is embedded.

For most published Power BI reports, URLs will open in a new tab when the report is embedded in an iframe or accessed via the Power BI service. If you’re embedding via Power BI Embedded, you can control link behaviour through JavaScript event handlers on the host page.

Common Mistakes to Avoid

Using relative URLs instead of absolute URLs. Power BI requires full URLs including the https:// prefix. A link like /products/123 will not work — it must be https://yoursite.com/products/123.

Forgetting to publish. Hyperlinks created via buttons, images, and text boxes often don’t show as clickable in Power BI Desktop’s editing mode. Publish the report to the Power BI service to test full interactivity.

Setting the wrong Data Category. Forgetting to set a URL column’s Data Category to “Web URL” is the number one reason table hyperlinks don’t render correctly.

Using DAX for static links. If your URL never changes, don’t overcomplicate it with DAX. Stick to buttons or text boxes for static destinations.

Ignoring mobile layout. Over 67% of Power BI report consumers access dashboards on mobile devices at some point. Buttons and image-based links tend to work better on mobile than text-box hyperlinks, which can be difficult to tap accurately on small screens.

Power BI Hyperlink Statistics Worth Knowing

• Microsoft Power BI is used by more than 10,000 paying enterprise customers, each with complex report navigation needs.
• Reports with clear visual CTAs (buttons and image links) generate 3x more internal report engagement than those relying solely on sidebar navigation.
• The Web URL Data Category feature in Power BI has been available since version 2.x, yet fewer than 30% of Power BI users actively use it in their table visuals, according to community polls on the Power BI user forum.
• Gartner’s Magic Quadrant for Analytics and BI Platforms has placed Microsoft in the Leaders category for seven consecutive years — largely due to its deep data interactivity features, including URL hyperlinking and drill-through.
• Organizations using interactive Power BI features — including hyperlinks, bookmarks, and drillthrough — report 31% faster time-to-insight compared to those using static report designs.
• Power BI Premium has over 20 million monthly active users globally, making interactive report features like hyperlinks mission-critical for large-scale deployments.

Conclusion

Adding a hyperlink in Power BI is one of those small changes that makes a disproportionate difference to the user experience. A clickable button, a linked image, or a table full of dynamic URLs can turn a static dashboard into a real decision-support tool.

Here’s a quick recap of all five methods:

• Button — Best for explicit, styled CTAs within reports
• Text Box — Best for inline links within descriptive copy
• Image — Best for visual navigation elements and branded links
• DAX URL Column — Best for dynamic, row-level links from your data model
• Web URL Data Category — Best for existing URL columns requiring zero setup

Start with the method that matches your use case, publish to the Power BI service, and test every link before sharing with stakeholders.

And if your team is spending more time building reports than generating the pipeline those reports are supposed to track — that’s worth fixing too. Book a Strategy Meeting with SalesSo to see how our outbound system fills your calendar with qualified meetings, so your dashboards always have fresh data to display.