Forum Discussion

AlessandroBet's avatar
AlessandroBet
Icon for Helper V rankHelper V
1 year ago
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...
Need Help
  • AlessandroBet's avatar
    AlessandroBet
    1 year ago

    Removing the column parameter it works

AlessandroBet's avatar
AlessandroBet
Icon for Helper V rankHelper V
1 year ago

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's avatar
danextian
Icon for Super User rankSuper User
1 year ago

Can you please post both queries? new and old.

  • AlessandroBet's avatar
    AlessandroBet
    Icon for Helper V rankHelper V
    1 year ago

    how can i post the query?

    • danextian's avatar
      danextian
      Icon for Super User rankSuper User
      1 year ago

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

       

      • AlessandroBet's avatar
        AlessandroBet
        Icon for Helper V rankHelper V
        1 year ago
        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"