Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
chrisnewman
Helper I
Helper 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 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.

10 REPLIES 10
chrisnewman
Helper I
Helper 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.

papaye667
Regular Visitor

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
Helper I
Helper I

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.

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
Helper I
Helper I

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
Helper I
Helper I

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
Helper I
Helper I

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

amitchandak
Super User
Super User

@chrisnewman , Unless you have enabled capture DB changes in incremental setting, it should refresh based on incremental logic or full refresh

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.

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.