Analysis Services Tabular Refresh errors: The server sent an unrecognizable response.

Question

This started after updating the on-premises data gateway. We reverted back to a previous version of the gateway but are still receiving this error. When we go to refresh a tabular data model the refresh process runs for a time and then the query seems to end but it shows this final line:
"
The server sent an unrecognizable response.
Run complete
"

If we process a refresh from SSMS by connecting to the Azure Analysis Services server we see the same error as it processes.
"
Finished Analyzing\Encoding segment 0 for the 'xxxxxxxx*NameOfPartionBeingProcessedxxx partition.

The server sent an unrecognizable response.

Run complete"

Does anyone have any suggestions? The tabular data model itself has not changed.

Answer 1

Hello @AConfusedUser ,

Welcome to the MS Q&A platform.

Could you please let us know if this is an intermittent issue, or are you getting this error whenever you refresh the tabular model?

Can you please try to process a single table and see if it is successful?

Some operations such as long-running queries, refresh operations, and query scale-out synchronization can fail if a server resource moves to a different node.

Also, can you please try using Asynchronous refresh with Rest APIs? This will minimize any potential issues in long-running refresh operations.

Here is the document: https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-async-refresh

Please let me know if you have any further questions.