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 UserYou mentioned there are 14 csv files but the first filter step is for one file.
Is all the detail in this one file?
Post PatronSo. 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
I build a relationship model based around "job number" each csv containing that info. Our time management web site is Workflow Max and it reports out time, invoicing, costs etc as different reports. so my owkr around was to export each report that I might need and then make the relationships 1 to many from a job list. The code I pasted in was for the job list.
I am currently right clioking and individually refreshing each table. And a third of the way through they have all loaded the rows without errors. A refresh all is flashing something but its a fraction of a second so I can not see what triggers it
Thanks for your help though. As I said it works in the service so worst case I publish then refresh that one to get my reports to display.- KNP
Right, 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?