Add hyperlinks to a table

Is this page helpful?

This topic teaches you how to use Power BI Desktop to create hyperlinks. Then use either Desktop or Power BI service to add those hyperlinks to your report tables and matrixes.

Table with hyperlinks

Note

You can create hyperlinks in tiles on dashboards and text boxes on dashboards on-the-fly using the Power BI service. You can create hyperlinks in text boxes in reports on-the-fly using Power BI service and Power BI Desktop.

You can create hyperlinks in tables and matrixes in Power BI Desktop, but not in the Power BI Service. You can also create hyperlinks in Excel Power Pivot before you import the workbook into Power BI. Both methods are described below.

The procedure for adding a hyperlink depends on whether you've imported the data or connected to it using DirectQuery. Both scenarios are described below.

For data imported into Power BI

  1. If the hyperlink doesn't already exist as a field in your dataset, use Desktop to add it as a custom column.

  2. In Data view, select the column and in the Modeling tab choose the dropdown for Data Category.

    Data category dropdown list

  3. Select Web URL.

  4. Switch to Report view and create a table or matrix using the field categorized as a Web URL. The hyperlinks will be blue and underlined.

    Blue and underlined links

    Note

    The URLS must start with http:// , https:// or www.

  5. If you don't want to display a long URL in a table, you can display a hyperlink icon Hyperlink icon instead. Note that you can't display icons in matrixes.

    Select the chart to make it active.

    Select the Format icon Paint roller icon to open the Formatting tab.

    Expand Values, locate URL icon, and turn it to On.

    Turn on URL icon

  6. (Optional) Publish the report from Desktop to Power BI service and open the report in Power BI service. The hyperlinks will work there as well.

For data connected with DirectQuery

You can't create a new column in DirectQuery mode. But if your data already contains URLs, you can turn them into hyperlinks.

  1. In Report view, create a table using a field that contains URLs.
  2. Select the column, and in the Modeling tab, choose the dropdown for Data Category.
  3. Select Web URL. The hyperlinks will be blue and underlined.
  4. (Optional) Publish the report from Desktop to Power BI service and open the report in Power BI service. The hyperlinks will work there as well.

Another way to add hyperlinks to your Power BI tables and matrixes is to create the hyperlinks in the dataset before you import/connect to that dataset from Power BI. This example uses an Excel workbook.

  1. Open the workbook in Excel.

  2. Select the PowerPivot tab and then choose Manage.

    Open PowerPivot in Excel

  3. When PowerPivot opens, select the Advanced tab.

    PowerPivot Advanced tab

  4. Place your cursor in the column that contains the URLs that you'd like to turn into hyperlinks in Power BI tables.

    Note

    The URLS must start with http:// , https:// or www.

  5. In the Reporting Properties group, select the Data Category dropdown and choose Web URL.

    Data category dropdown in Excel

  6. From the Power BI service or Power BI Desktop, connect to or import this workbook.

  7. Create a table visualization that includes the URL field.

    Create a table in Power BI with the URL field

Considerations and troubleshooting

Q: Can I use a custom URL as a hyperlink in a table or matrix?
A: No. You can use a link icon. If you need custom text for your hyperlinks and your list of URLs is short, consider using a text box instead.

Next steps

Visualizations in Power BI reports

Basic concepts for designers in the Power BI service

More questions? Try the Power BI Community