How to find why's Errors?

Question

How to find where is the error? &nbsp;it's nothing under the table.&nbsp;

phil_seamark · Answer

Hi&nbsp;Anonymous&nbsp;So are you clicking here to get that view? &nbsp;(no filters set?)&nbsp;&nbsp;

anonymous · Answer

Phil_Seamark&nbsp;Yes, i did, but nothing there.&nbsp;&nbsp; thanks.

marcelbeug · Answer

Some errors may not show up in the Query Editor, but are still reported as error when data is loaded into the data model.

An example would be that you have decimals in numbers that should be whole numbers as demonstrated in this short video.

I reported this as an issue with Microsoft and was told this is by design... :smileyfrustrated:

gilbertq · Answer

Hi&nbsp;MarcelBeug&nbsp;Yes that is true, because when data is loaded into the Query Editor it only Samples the first 200 rows.Whilst when you load the data from the Query Editor into your Power BI Model it loads the entire dataset, and it is sometimes only then that it will then produce an error.&nbsp;What I can suggest is if you know that your data has got, then format the column data type accordingly, as Power BI is doing a best educated guess.&nbsp;Alternatively you could change the column to Text to see what different data types there are, and then once you know how to resolve the issue, go back into the Query Editor, resolve the data issue and try again?

marcelbeug · Answer

GilbertQAdding a column has nothing to do with loading data into the query editor; otherwise both can&nbsp;result in data mismatching the column's data type.&nbsp;AnonymousSo our best guess is that you have data somewhere in your table/query that doesn't match the column type, which could have&nbsp; happened&nbsp; at data load or by adding a column.&nbsp;

Forum Discussion

How to find why's Errors?

5 Replies

Related content

Utterly perplexed why I'm getting error messages when refreshing this model

why use surrogate key

"Sorry we couldn't find that report" error

tool to find measures relationship

Why is DECLARE not supported (Error)?