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.
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.After much back and forth with Alteryx and our IT group I was able to do the same... had to create a service principal with all rights needed to read and write to the environment, had to make sure correct version of ODBC driver was installed, had to open a port on the firewall. But after all that I can select from lakehouse and data warehouse objects, and I can write to the warehouse. However, I've also found writing to the warehouse extremely slow. Workflow runs in 15sec when running without the final write action or when writing to CSV, but takes 20min to run writing to a warehouse table. Not a huge data volume (CSV is only ~75kb). Would love to hear if anyone has resolved this. I'm not sure if it's an alteryx issue, an ODBC driving issue, or a fabric issue.
