Forum Discussion
Possible to get hyperlink data from textfield?
Hi phyten,
Currently, we are not able to get hyperlink data from text field after importing data from Excel file to Power BI Desktop.
One possible method is to separate the text data and hyperlink data into different columns in Excel, then import the Excel file to Power BI Desktop. That way, you are able to create a table or matrix using the hyperlink field categorized as a Web URL. You can check the example in the following screenshots, for more details, please review this article: Hyperlinks in tables.
Thanks,
Lydia Zhang
Thanks for your answer. Anonymous
The "problem" is I am downloading large datasets of excel on a daily base and editing excel with command line is a pain in the *** since all of this should run automatically on a server.
Would be nice if this could become a feature in the future.
For now I found a workaround with a custom column within powerBI since the domains i want to visit follow the rule of
="staticdomain.com/static/"&[Key].
But then again this is not a nice solution since this is only possible due to coherent URLs. But maybe someone with the same problem can also use this meanwhile
I also was trying to mask the hyperlink with text so that I don't see the link itself but rather a text.
To reference the picture above.
Dispaly the text of column1 click on it within a table and it opens the link stored in column2.
Clicking a link is a ugly solution. People rather want to click keywords.
regards
Hi phyten,
Unfortunately, there is no better method besides editing Excel file to work around this issue.
Regarding to your requirement, you can submit a new idea in the Power BI ideas forum or add your vote in the link that ImkeF provides.
Thanks,
Lydia ZhangRegarding my second question whether it is possibel to just show a placeholder/keyword for the link to click I found a solution.
http://analyticsavenue.com/power-bi-shorten-hyperlink-url/