Forum Discussion
chrisnewman
3 years agoAdvocate I
Some 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 ...
chrisnewman
2 years agoAdvocate I
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
2 years agoNew Member
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.
- OwaisAkber2 years agoFrequent Visitor
Hi Skalgrin, thanks. Your reply solved my problem