Adding additional data column when someone exports data from a table in PowerBI online

[JuliaGarside]

I have a dashboard where one of the tabs is a simple table with about 10 columns of data. One of my columns is an ID number that links to the relevant folder on our intranet. The folder's hyperlink is a seperate column that I do not have displayed for space reasons, but the link is functional when someone clicks on the ID number, using conditional formatting in PowerBI Desktop. 

The problem is that when someone exports the table into excel, the hyperlink column does not download, as it's not officially a part of the table. Is there a way to either maintain the hyperlink in the ID number column, or add an additional column that is the hyperlink data, when someone exports the data from a PowerBI dashboard online? 

Thank you!

[Anonymous]

Hi @JuliaGarside 

@lbendlin Thank you very much for your prompt reply and here allow me to share some of it.

You need to generate the table containing the link in power bi desktop.

If the file is stored on SharePoint, you can copy a link to the file from the SharePoint site and use this link to generate the table in Power BI.

Solved: hyperlink to external excel files from Power BI Da... - Microsoft Fabric Community

Regards,

Nono Chen

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

[lbendlin · Accepted solution]

The folder's hyperlink is a seperate column that I do not have displayed for space reasons

Enable the URL icon option, or disable auto column sizing and make that column really narrow.

[JuliaGarside]

Thanks! I ended up doing this and it works. Not quite as perfect as if PowerBI kept the hyperlinks when you download the data, but close enough. 🙂