Getting the following error message when refreshing data model: "Request Rejected by Server TableauException: [Microsoft][ODBC Driver 17 for SQL Server]Invalid cursor state."

Question

I have a data model connecting to some tables in Azure Synapse using the available connector. I've noticed that the data model throws the following error message when attempting to refresh. Unfortunately, haven't had any luck trying to fix this issue so far and so any help would be appreciated on this:

"Request Rejected by Server TableauException: [Microsoft][ODBC Driver 17 for SQL Server]Invalid cursor state"

Jeff D · Accepted Answer

If the problem is intermittent, here's another KB article that might help:  https://issues.salesforce.com/issue/a028c00000yGAFAAA4/tableau-cloud--refreshing-an-azure-synapse-extract-results-in-an-error-odbc-driver-17-for-sql-server-invalid-cursor-state

Mahnoor Raza · Answer

Thank you both! Adding SET NOCOUNT ON seemed to do the trick.

Getting the following error message when refreshing data model: "Request Rejected by Server TableauException: [Microsoft][ODBC Driver 17 for SQL Server]Invalid cursor state."

Tableau Server

Risorse di formazione correlate

Ulteriore assistenza