Forum Discussion
Advocate ISome data sources not refreshing when refreshing through Home->Refresh
I've a pbix that I use Home->Refresh button to refresh from an SQL database. 90% of the tables update fine, but a few of them consistently need me to right click on the select the table on the right in Fields, click the three dots and select Refresh Data. I can't work out why this is happening and also how to force them to Refresh if I use Home->Refresh. I 've checked that they are all have 'Include in report refresh' ticked.
My only thought is that Powerbi doesn't think the underlying SQL table has changed but since my import query includes a parameter that only brings in certain data, the data I need to be refreshed into Powerbi desktop will be different. How can I force it to refresh them even if it thinks they haven't changed? Thanks in advance.
14 Replies
chrisnewmanAnyone else able to help! It's pretty debilitating having to check all my tables each time I refresh.
- chrisnewman
Would really appreciate any other thoughts on this. It seems to be pretty fundamental that a 'Refresh' just chooses not to refresh half a dozen tables every time and that these need to be manually forced.
- chrisnewman
I'm still hoping for someone to help me out on this, as I a) have to waste lots of time manually forcing some tables and b) if I miss one then I have to redo a lot of work.
- chrisnewman
Still no-one able to help with this? Its seems to be a pretty critical issue i.e. you think Powerbi should refresh but it decides that it will skip some tables as it erroneously doesn't think they'vre changed.
- chrisnewman
Any tips on how I get anyone to help with this? Or do I just shout into the void for the rest of eternity?
- chrisnewman
I'm afraid not and it continues to be very frustrating and causing business issues. We've had to take the apporach of trying to identify which tables don't refresh and then manually refreshing each of those every time - this has to happend multiple times a day.
See my other reply - basicly in querry list in power query view (editing of query), right click the query and you need to select (unknowingly unselected) option "include in query update". You have to find the particular affected query, it is not visualy represented.
Hi Skalgrin, thanks. Your reply solved my problem
- amitchandak
Super User
chrisnewman , Unless you have enabled capture DB changes in incremental setting, it should refresh based on incremental logic or full refresh
- chrisnewman
Thank you very much for picking this up amitchandak. That's pretty much the nub of my problem. It 'should' refresh but it doesn't. My refresh queries are import queries if that makes a difference? Where do I see if this is the case "enabled capture DB changes in incremental setting" - although I don't recall every haveing set this.
RuchitaHelper I
Have you found the solution. I am also dealing with the same issue. I am doing a refresh from Power BI service but only few files are getting refreshed.
Hi,
I was facing the same issue (items not updating in scheduled refresh nor with the home->refresh button) and resorted to manually refreshing the query with the 3 dots contextual menu in the 'Fields' panel.
The solution for me was to open PowerQuery window, right click the query in the left 'Queries' panel and tick the option "include in report refresh" as it was somehow unticked.
Hope this fixes your issue as well.
CheersI am having the same issue. I checked my queries and the "Include in report refresh" is selected but the table still does not refresh with "Home->Refresh". I hover over the table and it shows a different refresh date from the other tables that did refresh.
