Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JuliaGarside
Regular Visitor

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

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!

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

View solution in original post

3 REPLIES 3
v-nuoc-msft
Community Support
Community Support

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
Super User
Super User

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.

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. 🙂 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.