Forum Discussion
Hyperlinks pulling as 0 in Power Query
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.
Power Query imports the value stored in the cell, and if the cell’s formula results in something that Power Query interprets as zero, it will show zero. Also, Power Query does not evaluate Excel formulas — it only reads the result that Excel stores.
In your case, the HYPERLINK() function returns a clickable link in Excel, but Power Query reads the underlying value, which might be numeric or an empty string converted to zero. So you need to add a helper column manualy or using VBA
My confusion is how it's interpreting it as zero? Because all the texts in the hyperlinks are different numbers. The one I used in the example was 104658, but it still pulls as zero...