View Errors. OK, Where are they?

Hi comish4lif2 ,

In general this happens when there are no errors in the query, but errors occur when the query results are loaded into the data model.

Examples:

• unique key values in Power Query (case sensitive), that are not unique when loading (case insensitive), 
• numbers with fractions in a column with data type Int64.Type (Whole Number),
• etcetera.

Or you can have a try.

In power query-> "remove rows" section, click remove errors and check if error disappeared. 

Maybe some calculations that  used in the query resulted in "NaN" and "Infinity" in some cells which were actually the errors.

converted the columns to "text" from decimal # in the query editor and then replaced values (NaN, Infinity) with Blank. and then converted the columns back to decmal # and saved it.

Please choose a way which suits you.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.