Forum Discussion

skopcak's avatar
skopcak
Helper I
9 years ago

Hyperlink in Power Query Editor

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

 

Need Help

4 Replies

  • hugoberry's avatar
    hugoberry
    Responsive Resident
    9 years ago

    On  Data tab > Modeling menu> Properties segment

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

     

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    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.:smileyhappy:

     

    Regards

    • skopcak's avatar
      skopcak
      Helper I
      9 years ago

      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's avatar
        v-ljerr-msft
        Microsoft Employee
        9 years ago

        Hi skopcak,

         

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

         

         

        Regards