Forum Discussion
Failed to save data to Fields
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.
What is "Fields" ? Are you doing this in Excel, or in a Dataflow Gen 2, or somewhere else?
Can you include a screen shot of the error, to include the background program in which you are working? I am with lbendlin on this one, it doesn't sound like a Power BI error from Power Query.
Of Course, here is the screenshot
First, Sorry for taking alot of time to reply. And I'm talking about Power BI.
And here is a screenshot for the error.
