Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

PowerQuery: URL data type option not available

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.

  • Anonymous ,

    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.

     

     

2 Replies

  • Arul's avatar
    Arul
    Super User

    Anonymous ,

    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.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      ah, got it! Thanks!