Forum Discussion

JP-Ronse's avatar
JP-Ronse
Helper II
8 years ago

convert back to hyperlink

Hi,   I ran a query on an Access database and one of the fields is an hyperlink field. The hyperlink is a link to a document/file on a server/sharepoint.   Loaded into Excel, the "hyperlinks" are...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi JP-Ronse,

 

If I understand you correctly, you should be able set Data Categories for that field to 'Web URL' in PowerPivot to show it as  a clickable hyperlink in Excel Power View. For more details about how to Set Data Categories for fields in PowerPivot, you can refer to this article. :smileyhappy:

 

ExcelData-37

 

 

Regards

JP-Ronse's avatar
JP-Ronse
Helper II
8 years ago

Hi,

 

I googled this solution already, anyway thanks for the suggestion, but I don't need a pivot on the result, it is just a report and was hoping that it could be done with PQ. I wrote the query in the Access database and the exported result was a hyperlink.

 

I've found some work-arounds to convert the text to hyperlink. The remaining question is why PQ does not detect the field type and handle it appropriately.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Would you mind sharing your work arounds?  I'm trying to do something similar and would appreciate the help!

     

    Thanks!

    • JP-Ronse's avatar
      JP-Ronse
      Helper II
      8 years ago

      Hi,

       

      I do remember me the exercise but I am very sorry I can't remember the work-arounds.