Forum Discussion

AlessandroBet's avatar
AlessandroBet
Helper 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

danextian's avatar
danextian
Super User
1 year ago

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

AlessandroBet's avatar
AlessandroBet
Helper V
1 year ago

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

    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's avatar
    AlessandroBet
    Helper V
    1 year ago

    Removing the column parameter it works