CSV File Not updating

[swb128]

Hi,

I have a CSV file that I updated in excel (Changed the data in a couple of cells in 1 of the columns). When I go to table view in Power BI, I see the old data. I have hit Refresh data a number of times to no avail. Then I removed the file from the model and closed Power BI. Then reopened it and went to 'Get Data' and loaded the CSV file all over again and the old data is still there. I have checked the path to make sure that it was pulling the data from the right folder and it all looks correct. Not sure what is wrong.

swb1

[Praful_Potphode]

Hi @swb128 ,

as mentioned by @PhilipTreacy  please provide more information.

from the infromation it looks like your power query steps are not loading .

share the details like location of the file,connector you are using to assist you further.

Thanks and Regards,

Praful

[swb128]

Thanks for Responding! I changed the path of the file that I am having trouble with Off of OneDrive to my local drive, but the issue still remains.

[PhilipTreacy · Accepted solution]

@swb128 

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

[swb128]

Thanks! That worked😁 Grateful for your help.

swb128

[PhilipTreacy]

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

[swb128]

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"