cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Data Refresh with CSV files

I have a CSV file named Employees.csv When I orginally imported it, I had 34 rows in the file. I have since added a few more users to the file and now my file has 50 rows. When I refresh the data, either through the Refresh button or through right clicking the table and choosing refresh, I am only getting 34 rows updated. Should I expect the new data in the file to import or do I need to manually import the new data? If I need to manually import it, is there any way to overwrite the current table with the contents of the file?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Continued Contributor
Continued Contributor

Re: Data Refresh with CSV files

Hi bherring1979,

 

I tried the same operation that you did, but for me it works. Try look to the main menu under "Options and settings", choose "Options". In the windows look under "Global options" to see the total amount of the cache, and under "Current file" / "Relations" see if the first and the third field are checked.

Let me know if it works.

 

Have a good coding

View solution in original post

5 REPLIES 5
Highlighted
Super User I
Super User I

Re: Data Refresh with CSV files

@bherring1979 If using Dekstop tool then check whether the location of CSV file is as provided in query editor. If uploaded to Power BI Service then you will need a Personal Gateway to refresh the latest data.

If not above any error message you are getting when refreshing ?

Highlighted
Frequent Visitor

Re: Data Refresh with CSV files

I am using the desktop version. I have not changed the name of the file or its location, just edited the file in place. I do not get any errors when refreshing, it just doesn't grab the new data.

Highlighted
Continued Contributor
Continued Contributor

Re: Data Refresh with CSV files

Hi bherring1979,

 

I tried the same operation that you did, but for me it works. Try look to the main menu under "Options and settings", choose "Options". In the windows look under "Global options" to see the total amount of the cache, and under "Current file" / "Relations" see if the first and the third field are checked.

Let me know if it works.

 

Have a good coding

View solution in original post

Highlighted
Frequent Visitor

Re: Data Refresh with CSV files

Thank you! I cleared the file cache which was 1.7GB and tried the refresh and it worked.

Highlighted
New Member

Re: Data Refresh with CSV files

Hey guys,

 

I have a same issue.

Using 4 csv flies from local drive as data source. I tried removing some rows in data files to check whether the refresh works on my report. Funny enough it works for 2 of them but it doesnt for remaining 2.

 

I followed above instructions however it does not work for me.

Any suggestions?

 

Thanks,

Petr

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors