Refresh failing

[Udayreddee]

Hi,

I am trying to perform a scheduled refresh. The data sources are SQL SERVER and few CSV/EXCEL files. The refresh takes a really long time and has been failing always. Using OAuth2 authentication, I have also set up incremental refresh. The SQL SERVER tables have around 7M rows. I am not sure if this is a timeout error or something else.

Thanks

[Anonymous]

Hi @Udayreddee ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

Best Regards,

Yuna

[Udayreddee]

Hi,

Still the issue is not resolved, I have tried all the below steps you suggested, please help me in this

Data source :- Azure sql server

[Anonymous]

Hi @Udayreddee ,

Do you connect to SQL Server in Direct Query mode? Have you tried to update the latest version of Gateway and then re-configure your credentials?

Best Regards,

Yuna

[Udayreddee]

Please provide link for gateway latest version!

[Anonymous]

Hi @Udayreddee ,

Please refer to the following downloading link.

Download On-premises data gateway from Official Microsoft Download Center

Best Regards,

Yuna

[Fowmy]

@Udayreddee 

Please expand the error message and check the reason for the failure. 

[Udayreddee]

Error Detail.
{"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the SQL source are invalid.

This is the error message i got.

[Fowmy]

@Udayreddee 

As per the error message, the cause seems to be the incorrect credentials, please re-check the credentials and try.

[Udayreddee]

The credentials which i have given are correct but still getting same error.

Refresh works fine in Power BI desktop but Fails in Power BI service.

I have also parallely set up for Incremental refresh on other dataset, from then we are facing this Issue, before schedule refresh was working fine.