Forum Discussion
Solved
Data refresh with CSV file
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...
Removing the column parameter it works
how can i post the query?
Right click a query and then click advanced editor. Copy the code inside.
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"Please post both codes - the old that didnt refresh and the new one.
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