Forum Discussion
Understanding "loaded queries contained errors"
Community ChampionHello Anonymous
this depends of the type of error. In most cases these errors are caused on datatype-setting. So Power BI tries to identify you datatype using the first x rows. Then the transformation is applied. If on row x+1 this conversion is not possibile (lets say because normaly your column has a date but on this cell you have "N/A") then you have an error. However all data is processes but the error will not be transfered. In other scenarios I can also think that not all rows are transfered.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Thanks Jimmy801
when you say "However all data is processes but the error will not be transfered" what do you mean? what will happen to the row where the error appear? and to the specific cell of the error? how will it be treated when counting/visualizing etc.?
- Jimmy801
Hello Anonymous
if the error is only in one celle (like I mentioned when applying data type transformation) then a date will be visualized in the report, but if you have maintained "N/A" and transforming this to a date, then "NA" will not be visualized.
BR
Jimmy