Hello, I have an excel file with a vlookup formula in it. I'm attempting to export this file into Power BI. When I load the file into Power BI the column with the vlookup formula in it returns errors....

Hello,

I have an excel file with a vlookup formula in it.  I'm attempting to export this file into Power BI.  When I load the file into Power BI the column with the vlookup formula in it returns errors.  How do I fix this?

One thing to note is that before loading the excel file into power BI, no errors appear within the excel file.  It's only when the file gets loaded into Power BI that the errors appear in the power query editor of the vlookup column of the excel file.