cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AliceW
Post Prodigy
Post Prodigy

Exported Excel from report - how to convert URL links to from text to URL links?

Hello everyone,

I have this table in a Power BI report. One field is the URL link to a Salesforce Opportunity. Clicking on the said URL link works fine in Power BI (it opens the link in a new tab).

However, when I export the table, the URL link is a text one. The only way to make it 'clickable' is by selecting it and, in the Formula Bar above, click Enter. It's terrible to replicate it to thousands of lines.

My question is, is there a way to transform the text into an URL link automatically?

Big thanks,

Alice

2 ACCEPTED SOLUTIONS
AliceW
Post Prodigy
Post Prodigy

I found this solution: create a new column and =HYPERLINK([@URL],"URL"). It works, but ideally I'd like the users to not have to build it themselves...

View solution in original post

RicoZhou
Community Support
Community Support

Hi @AliceW 

Please make sure Web URL are the data category not the data type in Power BI. Your Url column are in text type.

2.png

I think when you export your data from Power BI to excel, it won't keep the data category in Power BI. So you will find the data in Excel is text type. I suggest you to create a new column by code in excel to convert the column to hyprelink.

=HYPERLINK(A1)

Result is as below.

1.png

 

Best Regards,
Rico Zhou

 

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

View solution in original post

3 REPLIES 3
AliceW
Post Prodigy
Post Prodigy

I found this solution: create a new column and =HYPERLINK([@URL],"URL"). It works, but ideally I'd like the users to not have to build it themselves...

View solution in original post

RicoZhou
Community Support
Community Support

Hi @AliceW 

Please make sure Web URL are the data category not the data type in Power BI. Your Url column are in text type.

2.png

I think when you export your data from Power BI to excel, it won't keep the data category in Power BI. So you will find the data in Excel is text type. I suggest you to create a new column by code in excel to convert the column to hyprelink.

=HYPERLINK(A1)

Result is as below.

1.png

 

Best Regards,
Rico Zhou

 

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

View solution in original post

Thanks, Rico, the Data category is set to URL in Power BI, and the link works perfectly.

Yes, the hyperlink formula in Excel seems to be the only solution. Perhaps Power BI will provide a simpler way in the future (fingers crossed).

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.