Forum Discussion
Using Alteryx with Fabric
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:
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.