Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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.
Solved! Go to Solution.
@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 ,
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.
ah, got it! Thanks!
| User | Count |
|---|---|
| 57 | |
| 43 | |
| 32 | |
| 16 | |
| 13 |
| User | Count |
|---|---|
| 84 | |
| 70 | |
| 38 | |
| 27 | |
| 24 |