Forum Discussion
Solved
Hyperlinks pulling as 0 in Power Query
I have an excel file where one of the columns are hyperlinks, but when I pull the table into Power Query the whole column just shows zeros. I would like to get the text from the original file An exa...
Hi, I couldn't use the solutions provided, because the original file is not suposed to be edited in any way. I ended up creating a macro to copy the sheet (just values) I needed from the original file to the one I'm working on, and start the query from there. It's a little bit of a nuisance, but it works.
Hi ferlvovi,
Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.
Best regards,
Prasanna Kumar