IF excel has vlookup code , it will get error when import in Power BI

[Anonymous]

i have one excel with several sheet , one column A in sheet A using vookup column B in sheet B in same excel as first  picture , when i import it in Power BI , that column A return error as second picture , how to fix

[danextian]

Hi @Anonymous ,

You can either:

• right click the column header and click replace error. You can replace it with null by typing null or replace it with any other value
• or you can remove rows with errors which, of course, will remove the entire row altogether.
• 

[Anonymous]

but can i use vlook code when click replace error , and when i writing vlookup , the system does not show this code , it seems not avaliable in Power BI . 

[danextian]

Although the DAX functions are  similar to those of Excel, there is no  VLOOKUP in Power BI. Look into using LOOKUPVALUE. If the tables have a direct relationship and you are trying to create a calculated column from the many side of o a one-to-many relationship, you can use RELATED function. Note: LOOKUPVALUE expects a single result - unlike in Excel, it won't pickup the first match - it will throw an error.

[Anonymous]

oK，it may difficult for me to understand , let me do example :

1. i have import sheet A , with column A ; sheet B with column A and B in power BI ;

2, Now i want create column B in sheet A based on colunmn A ,  that means A1 value in sheet A , then system look for A1 value in sheet B , find the related B value , then return to B1 in sheet A . so how to modify qury .

[danextian]

you can use LOOKUPVALUE for that. But as previously mentioned, it doesn't work the way VLOOKUP in Excel does. For example, if your lookupvalue is A and there are two matching rows with different values in the other table, it will throw an error. As to the handling of errors like #N/A from Excel, please refer to my previous comments.

[ryan_mayu]

@Anonymous 

you can try to use IFERROR to remove errors in excel , then import to powerbi

or 

you can do the vlookup in powerbi

https://learn.microsoft.com/zh-cn/dax/lookupvalue-function-dax?wt.mc_id=DP-MVP-5004616