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.
Hi ferlvovi,
Thank you for reaching out to the Microsoft Fabric Forum Community.
This happens because Power Query doesn't evaluate formulas it only reads the raw value stored in the cell. When a hyperlink is created using a formula, Excel may not store the display text (like "104658") as the actual value, so Power Query ends up seeing it as 0 or blank. To fix this, you can try creating a helper column in Excel that extracts the display text as plain text. This makes it readable by Power Query.
Best regards,
Prasanna Kumar