Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
KNP
Icon for Super User rankSuper User
2 years ago

Can I get the entire code from the advanced editor rather than just the one step?

 

Just change anything that is sensitive before posting.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.