Power query not updating

[rich987652]

Hi - I have a problem with power query not updating all data from my source file.

My query was created from file / from folder, and I currently only have a single file in that folder at the minute. I have imported that data into power query with no issues currently, however if I change some data in the original file (in some of the columns) and re-save the file and refresh the query then power query is not reflecting those updates.

The columns that are not being updated have a percentage format not sure if that is causing an issue. The only reason I say that is if I change some other columns with a whole number format, then they are getting updated in power query.

I've search around for anyone having similar issues but can't find any.

Richard

 

[sandy666]

Hard to say something without any example which reflect your problem
maybe check status of source data type in this column and in the query table

 

[rich987652]

Hard to say something without any example which reflect your problem
maybe check status of source data type in this column and in the query table

I can't attach anything on here, so how can I show you this?

 

[sandy666]

you can
post a links to shared Excel files using GoogleDrive, OneDrive or any similar