Hyperlink in Power Query Editor

[skopcak]

Hello, Please give the query editor to create a hyperlink? When I then load into Excel and clicking my page loads. thank you for answer

[v-ljerr-msft]

Hi @skopcak,

Have you tried the solution provided by hugoberry above? Does it work in your scenario? If you still have any question on this issue, feel free to ask.

Regards

[skopcak]

Hello,
this option I have not found in Excel, you can do this in Excel via Power Query editor?

thank you for answer

[v-ljerr-msft]

Hi @skopcak,

In Excel, the same option is under Power Pivot -> Manage Data Mode -> Advanced -> Data Category.

Regards

[hugoberry]

On  Data tab > Modeling menu> Properties segment

Select Data Category as Web URL from thedrop down menue. This should do the trick