Forum Discussion

ferlvovi's avatar
ferlvovi
New Member
1 year ago
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...
Need Help
  • ferlvovi's avatar
    ferlvovi
    1 year ago

    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.

Chanty4u's avatar
Chanty4u
Frequent Visitor
1 year ago

Hi 

Use a Helper Column in Excel

Before loading into Power Query, create a helper column that converts the formula result into plain text

=TEXT(104658, "0")

=IF(ISFORMULA(A2), A2, TEXT(A2, "0"))

 

Then load helper column in power query 

ferlvovi's avatar
ferlvovi
New Member
1 year ago

Yes, that would work, but I don't want to have to alter the original file, mainly because I'm not always using the same one. In power query, I get the lastest file from a folder, and I would prefer to not have to create a column every time a new file is uploaded.