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

AConfusedUser 66 Reputation points
2022-08-17T18:59:53.987+00:00

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.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
437 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. BhargavaGunnam-MSFT 25,971 Reputation points Microsoft Employee
    2022-08-19T02:24:47.103+00:00

    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.

    1 person found this answer helpful.