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
Super UserRight, I thought the files were all the same format and then combined after, I understand, they all have different data.
Longshot, and really unlikely, but make sure you have the 'Include in report refresh' ticked on the queries.
If you click on the query in the query editor that the data is missing from in Desktop, I assume it doesn't show there either?
Post PatronI do have a few static data queries for lets say 2019 data. So I do have a few that do not fully refresh each run. So I untick Enable Load, but leave the Include in refresh button ticked
After going through all the sheets and individually refreshing. They all loaded and the report updated. Its really weird. Not the end of the world, just a frustration
- KNP
That is odd. Those are the worst issues to try and debug.
Glad it's (kinda) working now.