Forum Discussion
Refresh failing
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
9 Replies
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.
Udayreddee
As per the error message, the cause seems to be the incorrect credentials, please re-check the credentials and try.
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
Please provide link for gateway latest version!
Hi Udayreddee ,
Please refer to the following downloading link.
Download On-premises data gateway from Official Microsoft Download Center
Best Regards,
Yuna
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
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
