Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Excel data mismatch

When I import an excel table into power bi and then try and do a merge with an existing table from another data source. The excel data is not recognised. The lokkupvalue function appears to have the same problem. Any idea. Thanks

Status: Needs Info
Comments
v-jiascu-msft
Employee

Hi @bushman,

 

The data won't be the excel data when you import it into Power BI Desktop. It's a query of Power BI.

1. Were there any error messages?

2. What's the outcome?

3. What's the result of the function lookupvalue?

 

Best Regards,

Dale

Vicky_Song
Impactful Individual
Status changed to: Needs Info