Forum Discussion

cpshort7186's avatar
cpshort7186
Advocate I
1 year ago

Using Alteryx with Fabric

Is anyone successfully using Alteryx in combination with Fabric?  I have struggled to get alteryx to connect to a lakehouse or data warehouse and am finding that there does not seem to be much/any su...
data warehouse
Joshrodgers123's avatar
Joshrodgers123
Advocate V
1 year ago

My first suggestion would be to give up now 🙂 I tried going down this path. Alteryx support said, "We don't support Fabric". Makes no sense as it is just SQL Server.

 

You can get it to work by creating an ODBC connection using the SQL Server 18 driver.

 

If you are using an AD login with MFA, Alteryx will prompt you at least twice on every run for your credentials and MFA.

 

You will also receive this error when running a query any query: 

Input Data (1) Error SQLExecute: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]DECLARE CURSOR is not supported.

 

According to these docs: Error: "Cursors are not supported" or "Cursor support is not an implemented feature" when running a workflow against SQL Server or Azure Synapse (alteryx.com)

 

You need to add SET NOCOUNT ON to the end of all your queries.

 

It works, but not really to a point where it is very usable. My suggestion would be to use Fabric items to do your Alteryx work.

 

cpshort7186's avatar
cpshort7186
Advocate I
1 year ago

Thank you!  This is the suspicion I had and it's good to hear from another practitioner about the experience.