Forum Discussion
Post PatronPBI DEsktop not refreshing correctly
Hi everyone
I have an issue I have been observing for a couple of weeks and it has not resolved itself.
When I refresh manually my Desktop report it is not updating to the lastest data. The published one on the server is updating and appears correct.
The data are a series of CSV files stored in Sharepoint.
I deleted my credentials and re-entered them, but it is still doing it. Any suggestions? Its very odd.
example below:
Desktop table
Service version
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
16 Replies
- KNP
Super User
Not enough info to answer this.
Can you share your Power Query code (obfuscate any info that is sensitive)?
- Pmorg73
What 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.
- KNP
Sorry, I meant go to the advanced editor and copy/paste the code.
Make sure you paste it into a code block...
- KNP
You mentioned there are 14 csv files but the first filter step is for one file.
Is all the detail in this one file?
- Pmorg73
there are 14 versions of this type of code for each one
- KNP
Ok, that's not really the intended way of doing this. You could have one query to process all files, but I don't think I can solve that issue for you here. It would take a couple of hours consulting to do that.
- Pmorg73
So. Ijust ran the refresh, scrolled tot he bottom and watched. It flashed a warning message and closed. It was so quick i could not see what it was. So I am thinking now that one of my tables is not working which is killing the refresh. I feel that it is credentials so I will play with that area again. Is there a way to see error reports from the refresh?
- KNP
Not sure about a warning flashing up but if none of the queries have errors (e.g. all refreshing without error) then I don't think that is the issue.
If you have that many individual queries, how are you combining them at the end?
- Pmorg73
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
