Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
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...
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.
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.
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.
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...
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.
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.
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.
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).
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
69 | |
68 | |
40 | |
29 | |
26 |
User | Count |
---|---|
89 | |
49 | |
44 | |
38 | |
37 |