VLOOKUP working fine in Google Sheet but giving error in Power BI Query

[Anonymous]

Hi,

I am creating a power BI dashboard whose data source is the Google Sheet. The sheet used is populated using a vlookup from another sheet in the same google sheet document - screenshot below

But when I link this sheet in Power BI it is displaying as an error though vlookup is working fine in th google sheet:

 

Please help me to understand the reason why this might be happening and ways to resolve it.

@amitchandak @parry2k 

[Anonymous]

@amitchandak - thank you for your reply. 

But why is vlookup working fine in google sheet then. It should have been an error there as well if it had not worked correctly?

pls help

[amitchandak]

@Anonymous , Make sure it working properly on google sheet

https://www.ablebits.com/office-addins-blog/fix-vlookup-errors-google-sheets/