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,
Great to hear that it's working as expected on your end!. I would suggest accepting your approach as the solution so that it can benefit others as well. It would be really helpful for others in the community who might be facing similar issues and can address them quickly.
Thanks & Regards,
Prasanna Kumar