Getting the same refresh error each day when scheduling, but on-demand works fine

[Anonymous]

Hi all,

I am getting below error almost each day from the scheduled refresh, but works fine when using on-demand scheduling.

It is the same table which is mentioned in the error message each time. Is it a timeout problem or what?

[Anonymous]

Hi @Anonymous,

How do you configure the scheduler refresh? Do you schedule these refreshes on a busy time that power bi service processes with high workloads?

If this is a case, it may cause the issue due to not enough resources available. I'd like to suggest advance or postpone the refresh plans to avoid refresh in a busy time.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @Anonymous ,

I have tried to advance the refresh time today, but it still failed.

It is a messy report, so I will try cleaning it up today.

Would it be a problem if one user/account is setting up the gateway with his credentials while the sharepoint connection is set up with another users credentials?

[Anonymous · Accepted solution]

HI @Anonymous,

>>Would it be a problem if one user/account is setting up the gateway with his credentials while the sharepoint connection is set up with another users credentials?

Gateway Datasource does not need to use the same credentials as the gateway client signed in.  (For these dataset settings, it required to use the same as you publish pbix file configured on the desktop side or refresh will be failed due to configuring not matched)

BTW, you can also take a look at the following links about use end-users credentials to link to Datasource:
Manage your data source - SQL Server 

Configure Kerberos-based SSO from Power BI service to on-premises data sources 

Regards,

Xiaoxin Sheng