Forum Discussion
Post PatronPBI DEsktop not refreshing correctly
So after a little thinking and digging I figured it out.
At some time I had directly imported a Excel file for a sanity check on something. I removed it from the model, but the sample file locations still remained in power query. So even so they were not used any more they referred to a folder that no longer existed. so they caused the Refresh to fail. Individually refreshing my tables still worked but that was labourious. Went through 30 or so power queries to find 3 or so that were broken. Deleted them and then a full refresh worked. It miight be worth a suggestion to have a hold on the fresh screen so when there is an error message it is there long enough for oyu to read it ha. All goo dnow
Post PatronWhat the images show are simple tables from the data.It has worked for 3 years but has recently stopped using. There are 14 csv imports in to this model so picking out powerquery is hard in a small window. But I used stadard import from sharepoint importing.
Super UserSorry, I meant go to the advanced editor and copy/paste the code.
Make sure you paste it into a code block...