Forum Discussion

Anonymous-'s avatar
Anonymous-
New Member
2 years ago
Solved

Failed to save data to Fields

Hi, everytime I try to save data from power query to Fields the following error encouters me. " A Task's exception weren't observed by the waiting on the task or accessing its exception property. As ...
Need Help
  • ToddChitt's avatar
    ToddChitt
    2 years ago

    CSV as a source should be a piece of cake for Power Query to ingest. Is is possible that Excel is doing something to the data? Try openning the CSV file in a text editor program like Notepad or Notepad ++. Do you see any strange characters?

    IMHO I try to avoid letting Excel touch raw CSV and TXT files between the export from the source system and ingestion by Power BI. I have seen it royally mess things up, especially Zip Codes, which it looks like you have.

    Lastly, try the same file on your local C:\ drive. Maybe there are restrictions on your D drive. 

     

    Hope that helps.

ToddChitt's avatar
ToddChitt
Super User
2 years ago

CSV as a source should be a piece of cake for Power Query to ingest. Is is possible that Excel is doing something to the data? Try openning the CSV file in a text editor program like Notepad or Notepad ++. Do you see any strange characters?

IMHO I try to avoid letting Excel touch raw CSV and TXT files between the export from the source system and ingestion by Power BI. I have seen it royally mess things up, especially Zip Codes, which it looks like you have.

Lastly, try the same file on your local C:\ drive. Maybe there are restrictions on your D drive. 

 

Hope that helps.

Anonymous-'s avatar
Anonymous-
New Member
2 years ago

Thanks so much. I appretiate it 
I will try and see where the problem comes from.