PowerQuery: URL data type option not available

[TMielke]

Hi,

I have some data with URLs inside. When I load the data, PowerQuery sets its type to "text", but I would like to change ot to URL so I have hyperlinks. However, when I try to set the datatype in PowerQuery, the option "URL" is not available for me as it should be according to some forum posts. Was this option only added recently? I'm using PowerBI Desktop version 2.124.1554.0.

[Arul · Accepted solution]

@TMielke ,

It is not in Power Query Editor. In Power BI Desktop, once you load the data, select the text column where you have url's, then go to the 'Column tools' tab, where you will find the 'URL' option under 'Data Category.

[TMielke]

ah, got it! Thanks!