dealing with Excel #N/A

Posts: 25
Joined: Thu Aug 16, 2018 11:18 pm

dealing with Excel #N/A

Postby fb7894 » Wed Oct 02, 2019 12:51 am

I'm having problems where the Excel source I bring into PQ has #N/A results. Removing Errors in PQ does not seem to recognize these as errors.

How do you all deal with these #N/A cells?


Posts: 1097
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: dealing with Excel #N/A

Postby MattAllington » Sat Oct 05, 2019 7:48 am

Have you tried replacing the NA using power query before any “changes type” steps?
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 1 guest