Incremental Refresh in Power BI Desktop is not happening as requested

[Jack2710]

Hi Everyone,

I have recently created incremental refresh to one of the tables, after implementation it didn't refresh next day, I waited and checked for two days but didn't happen and I manually refresh the table.
Can you help me on this what I am missing.
And if we create incremental refresh in Power BI desktop and publishes in Power BI Services. In Services will it not refresh after a day. 
It would be very helpful

[MFelix · Accepted solution]

Hi @Jack2710 ,

The incremental refresh is used to refresh only a part of the data instead of doing everything single time a full refresh.

Incremental refresh is not a Schedulling refresh of your data.

A couple of thing you need to know about refreshs in Power BI:

• Refresh in Desktop is always manual, except if you are connected to live data
• When publishing a semantic model to the service and in import mode the refresh needs to be schedulle if you want it to run automatically (https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh)

So in you case when you setup the incremental you are only setting up the number of days that are going to be refreshed the previous values will be historical values that won't be refresh because they are already saved on your model, minimizing the amount of time used on the refresh.

What you need to do when you publish to the service is to configure the schedule refresh and then the incremental will work properly. You can check if everything is working well on the settings and then Refresh History.

[Jack2710]

 "Data Source Credentials" area is grayed out since yesterday to schedule refresh

[MFelix]

@Jack2710 ,

What is the datasource type you have?

[Jack2710]

vsts

[MFelix]

Are you using the same login credentials for the VSTS than for Power BI is it a single sign on system?

[Jack2710]

Now it is resolved, don't know why "Data Source Credentials" area was grayed out but today is it working fine.
Thank you

[MFelix]

Glad to hear.