Forum Discussion
Dataset Refresh Failure - No error message (Storage Mode - Mixed)
Hi Anonymous
No worries, if you have not heard of Tabular Editor then I would say you have done what everyone else has used the product for.
The only option is to enable additional logging on your Gateway Server to see what the logs say?
Thanks again for your response.
I have just tried another refresh, which has of course failed, and have reviewed the additional logs thereafter.
Nothing strikes me as an immediate cause for concern, but again, I'm no expert. This is something I did pick up on though, which means next to nothing to the likes of me: -
The longer errors are some variation of the below: -
DM.EnterpriseGateway Verbose: 0 : 2021-03-03T22:12:42.9174312Z DM.EnterpriseGateway b402c487-8b30-47d9-9c92-243e7c586f00 a3fd679b-35a0-a298-1ff5-399448b1baf1 MGGC 3fc53cf2-8a0e-4324-9e27-f8e7193f071b 36f9441d-5c48-4033-846f-21b812cf535f 36f9441d-5c48-4033-846f-21b812cf535f 92D52C70 [DM.GatewayCore] Retrieving database connection establishment to [<pi>System.Data.SqlClient:multisubnetfailover=True;applicationintent=ReadOnly;data source=*servername*;initial catalog=nethelpdesk;application name=PowerBIShared-DirectQuery:[Basic] Encrypted Credential information omitted</pi>]
Hi Anonymous
Can you connect from the Gateway server to the SQL Server instance?Hello, yes, I have just confirmed this now.
The server that is hosting the gateway connector happens to have an instance of SQL on, and is able to successfully connect to the remote SQL server instance.