Forum Discussion

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

13 Replies

    • Bibiano_Geraldo's avatar
      Bibiano_Geraldo
      Super User

      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.

  • 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?

     

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

      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
        Super User

        Can you please post both queries? new and old.