I am pulling a .csv file into Excel Office 365 using standard Power Query tools. Version 1908 Build 11929.20562.
I have removed all date columns in the file, but I'm still getting this error when I load to the data model. This is happening on multiple users' machines in our office. We've tried simplifying privacy settings and other features.
This is the source string
Source = Csv.Document(File.Contents("S:\OFP\Sources\3PL_AP_SPEND.csv"),[Delimiter=",", Columns=48, Encoding=1252, QuoteStyle=QuoteStyle.None]),
We've tried removing errors from individual columns and from the table
#"Removed Errors" = Table.RemoveRowsWithErrors(#"Filtered Rows"),
When there were date columns we tried adjusting locale info
#"Changed Type with Locale" = Table.TransformColumnTypes(#"Removed Errors", {{"Accounting Date", type date}}, "en-US"),
But the error message persists. Older spreadsheets that pulled data from this file are unaffected and can retrieve the updated info. But any new spreadsheet that tries to access this file gives the error.
It seems any attempt to change the type of any column from the .csv file triggers this message. If we pull in the data with no change to the column types (i.e. all are text) the data gets pulled into the model.
Has anyone else seen this behavior?
I have removed all date columns in the file, but I'm still getting this error when I load to the data model. This is happening on multiple users' machines in our office. We've tried simplifying privacy settings and other features.
This is the source string
Source = Csv.Document(File.Contents("S:\OFP\Sources\3PL_AP_SPEND.csv"),[Delimiter=",", Columns=48, Encoding=1252, QuoteStyle=QuoteStyle.None]),
We've tried removing errors from individual columns and from the table
#"Removed Errors" = Table.RemoveRowsWithErrors(#"Filtered Rows"),
When there were date columns we tried adjusting locale info
#"Changed Type with Locale" = Table.TransformColumnTypes(#"Removed Errors", {{"Accounting Date", type date}}, "en-US"),
But the error message persists. Older spreadsheets that pulled data from this file are unaffected and can retrieve the updated info. But any new spreadsheet that tries to access this file gives the error.
It seems any attempt to change the type of any column from the .csv file triggers this message. If we pull in the data with no change to the column types (i.e. all are text) the data gets pulled into the model.
Has anyone else seen this behavior?
