Forum Discussion
andreazambon
Helper V
Helper VPowerBI and Excel table with #N/A errors due to VLookUp
Hi there. I have an Excel Datasheet stored in Sharepoint, where I have some VLookUps formulas and lots of "#N/A" Errors. Of course if I try to import data from this sheet, PBI returns "Error" ...
Hi there,
I managed to handle my problem by replacing the errors with null whit powerquery. Seems that it works fine 🙂
andreazambonHelper V
Helper VHi there,
I managed to handle my problem by replacing the errors with null whit powerquery. Seems that it works fine 🙂