Forum Discussion
PowerQuery converting text to date automatically
Hi, I'm using PowerQuery to read in a .csv file. The key field for the file is a text field, and most records have a random alphanumeric string for this field, but I have a handful of records where ...
I'm not sure why, but I managed to get the data to ingest by modifying a filter step. Basically, I had a step that filtered on gift_date (the only Date field in the database), but changing that filter to be dependent on gift_fiscal_year (an Int) instead, seems to have made the model happy. Thanks for you help! I'm going to close this post now.
KNP
Super User
Super UserHi,
It sounds like it is the Change Type step that is automatically added that is causing you the problem.
You can either delete this step or change the problem column to 'type text'.