"Error SQLDriverConnect:" in ODBC Connection to Fabric

[Ali_288-1]

Hi all,

I'm trying to input data from Fabric. We've set up an ODBC connection which seems to be working, and allows us to see and select the tables in our Fabric environment. 

However when we run the workflow to actually pull this data, we get this error message --

  "Error: Input Data (1): Error SQLDriverConnect:"

There's no further details on that error - not clear what the specific issue is. Has anyone successfully input data from Fabric? Or seen that SQLDriverConnect error with no further detail? 

Things we've tried...

- installed Microsoft ODBC Driver 18 for SQL Server

- created ODBC connection on both User and System

[vizwithdan]

Are you getting the error in Desktop or on Server/Gallery?

[shancmiralles]

with my experience.. try and check your access to the server - your access to the DB.. hope this helps!
@Ali_288-1 

[bmk5072]

Were you able to figure this error out? The exact situation is happening on our setup. We're using Service Principal authentication, but get the same error. It lets us see the table in the Visual Table Builder, but running the query or even viewing Stored Procedures it shows that error without any details to go with it. Just curious if you found a solution/workaround?

[Ali_288-1]

Sadly no - we're going to have to push our Fabric content out to a SQL warehouse if we want to use it with Alteryx for the time being. I'm sure it'll change in time but currently it's an unsupported datasource, so Alteryx can't find a solution.