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.
Omid_Motamedise
Super User
Super UserAfter loading data into the Power Query, a step namely change type will be added, Remove that step.