Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

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

 

 

Need Help

6 Replies

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

      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's avatar
        danextian
        Icon for Super User rankSuper User
        2 years ago

        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.