Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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).
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
63 | |
63 | |
52 | |
36 | |
36 |
User | Count |
---|---|
80 | |
71 | |
58 | |
45 | |
44 |