Data refresh with CSV file

[AlessandroBet]

Hi,

i'm importing CSV file stored on google drive (ex: g:\database\CSV\test.csv) but when i refresh the data with PBI desktop it doesn't work.

I have already read all the similar post

Thanks

[danextian]

What does it show on the query editor preview? Try renaming the csv file and refresh again. If you don't get an error, you might be using a different file.

[AlessandroBet]

I get error if i rename the file but if i rename back the data are not refreshed.

To read the correct data i have to import again the file in thr new query

[danextian]

Can you please post both queries? new and old.

[AlessandroBet]

how can i post the query?

[danextian]

Right click  a query and then click advanced editor. Copy the code inside.

[AlessandroBet]

let
    Source = Csv.Document(File.Contents("G:\Drive\File.csv"),[Delimiter=",", Columns=17, Encoding=65001, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
    #"Promoted Headers"

[danextian]

Please post both codes - the old that didnt refresh and the new one.

[AlessandroBet]

Both code are identical except the new query loads 20 columns and old one loads 17. (3 are those added). 

I did several text and i get the data refreshed only if i create a new query selecting the same file

I have changed the name of forlder and file

I have moved the folder locally

If i rename folder and file i get error

I have copied the query

I have refreshed on both the enviroments

I suppose it is a bug of PBI

[danextian]

Normally, when you connect to a csv file, the connector automatically specifies the number of columns. If in the next refresh, more columns added, only the the number of columns specified are picked by the query. That parameter is optinal though.

[AlessandroBet · Accepted solution]

Removing the column parameter it works

[AlessandroBet]

I dont get any error. Looks like it doesnt read the new data 

[Bibiano_Geraldo]

Hi @AlessandroBet ,

Make sure that you do not have any step applied that removes new data to be added in power query.

Maybe filters.

To debbug, refresh the data in power query and go to your applied steps and check from top to bottom to see in which step this data desappear.

because if you reload the data in diferent table, and all data come from the same file, that mean theres step that filter data in your original table.

[Bibiano_Geraldo]

Hi @AlessandroBet ,

Why its doesn't work? its giving you an error?

Please give us more details. whats happen when you click the refresh button?