Some data sources not refreshing when refreshing through Home->Refresh

[chrisnewman]

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.

[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.

[Skalgrin]

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.

[OwaisAkber]

Hi Skalgrin, thanks. Your reply solved my problem

[papaye667]

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.
Cheers

[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 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]

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]

Anyone else able to help!  It's pretty debilitating having to check all my tables each time I refresh.

[amitchandak]

@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.

[Ruchita]

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.

[Skalgrin]

I had similar issue - in power query view I had to select the particular query, right click and tick "include in querry update". In my case, I probably missclicked during duplicating query. I am very dissapointed this option is not visualy reflected in querry list. Good feature, but nightmare stuff when unselected unknowingly.