Forum Discussion
CSV File Not updating
Try moving the file to a folder that is not backed up by OneDrive, like c:\temp
The issue may be that the file is not being loaded properly by OneDrive
Phil
Hi swb128
Can you reproduce the issue with a different CSV?
Where is the CSV stored? Local hard drive? Cloud?
Can you move the CSV to a different path (preferably a local drive) and see if that fixes the issue?
Phil
Thanks for responding! This is the Info from the Advanced Editor:
let
Source = Csv.Document(File.Contents("C:\Users\16199\OneDrive\Documents\Big Block Realty\Resources\Dashboards\RE data\San Diego\redfin-coral-springs-listings.csv"),[Delimiter=",", Columns=26, Encoding=65001, QuoteStyle=QuoteStyle.Csv]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Position", Int64.Type}, {"Price", Currency.Type}, {"Beds Baths Sq Ft", type text}, {"Beds", type text}, {"Baths", type text}, {"Square Feet", type text}, {"Key Facts", type text}, {"Property Link", type text}, {"Main Image", type text}, {"", type text}, {"_1", type text}, {"_2", type text}, {"_3", type text}, {"_4", type text}, {"_5", type text}, {"_6", type text}, {"_7", type text}, {"Address Comb", type text}, {"City", type text}, {"_8", type text}, {"State", type text}, {"Zip Code", Int64.Type}, {"Address SP1", type text}, {"Unit", type text}, {"Address", type text}, {"_9", type text}})
in
#"Changed Type"
