CODEWITHSUNDEEP
sql-serverazureazure-sql-databasessas
Souf
Souf

Reputation: 389

Analysis service connection closed by remote host (Azure SQL Database)

While trying to load the FACT table (~15M Rows) in Analysis Service from a Azure SQL Database, I always get this error after one hour:

Failed to save modifications to the server. Error returned: 'A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.);An existing connection was forcibly closed by the remote host. The exception was raised by the IDataReader interface.

I can't seem find the setting to change the timeout Azure SQL Server... Does anybody know where I can find this?

Upvotes: 1

Views: 1369

Answers (1)

Alexander Volok
Alexander Volok

Reputation: 5940

It can be that timeout is set on SSAS side rather than Azure SQL Database?

If you are using modern "Get Data experience (Power Query)" take a look on this thread:

SSAS tabular model timeout raised during processing

To check this, open your model source code by clicking on Model.bim and then F7 and search for keyword "timeout".

The target is to find something like this:

"options": {
          "commandTimeout": "PT1H"
        },

or

Source = Sql.Database("serverName.database.windows.net","databaseName",
[CommandTimeout=#duration(0, 2, 0, 0)])

Upvotes: 0

Related Questions