Forum Discussion
Using Alteryx with Fabric
What part are you trying to connect to? The SQL endpoints should be no problem for Alteryx. The Delta Tables might require Alteryx to understand Parquet.
I've tried connecting via "Microsoft Azure Data Lake Store" and "Microsoft Azure Synapse Analytics" and have been unsuccesful with both. My understanding is that Data Lake would be read-only, but that in theory I should be able to read/write to a Data Warehouse artifact via Alteryx.
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.
Thank you! This is the suspicion I had and it's good to hear from another practitioner about the experience.
Now try the actual option - Microsoft Azure SQL Database.
Unfortunately I have not been able to get this option to work either.
I got it working, but its slow as he......
And I dont know why.
But if you create a service principal and give it write rights on your lakehouse table - you can connect using oledb driver in alteryx with SP.
