Writing to Microsoft Fabric Warehouse?

[CullenJ]

Is anyone successfully writing data out from Alteryx to a Microsoft Fabric Warehouse? If so, how are you connecting to it? 

Any guidance much appreciated. (Bonus if you have it working with Alteryx Server!)

[GrowthNatives · Accepted solution]

Hi @CullenJ ,
Seems like you are facing a problem with writing to Microsoft Fabric Warehouse. As of now, Alteryx doesn’t yet offer a direct out-of-the-box connector specifically for Microsoft Fabric Warehouse, but you can successfully connect and write data to it using some smart workarounds.

Using Alteryx Server

1. Set up an ODBC connection:

   • Go to ODBC Data Sources on your machine

   • Set up a SQL Server ODBC DSN pointing to your Fabric Warehouse endpoint

   • Use the SQL endpoint from Microsoft Fabric (you’ll find this under “Warehouse > Connection string”)

2. In AlteryxServer:

   • Use an Output Data Tool

   • Select ODBC > Choose your DSN

   • Set the table name and write method

Credentials:
Use Azure AD authentication or SQL Authentication (based on your Fabric workspace security settings).

If using Azure AD, you may need to use a service principal or managed identity for Alteryx Server scenario

Note:
Use Credential Vault or a Gallery Data Connection to securely store your credentials

Make sure the Server user (Run-As account) has access to the Fabric warehouse

Permissions Checklist
Make sure the user or service principal you're using has:

• Read/Write access to the Microsoft Fabric Warehouse
• Workspace permissions if needed for dataset refreshes

Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!

🚀Let’s keep building smarter, data-driven solutions together! 🚀

[Yogesh1795]

Hi I did it just now.

Steps I did are, in my fabric workspace, I click on 3 dots of warehouse, then I copied the SQL endpoints. Then in Alteryx in input data tool, Set up Connection<Data Source<Microsoft SQL Server<oledb

In provider I choose "Microsoft ole dB DRIVER for SQL Server", click on next, in server name I pasted the SQL end points from Fabric.

Now the important part is to choose the - Enter information to log on to the server: in here you have to choose - Active Directory - Universal with MFA Support. 

In username write the complete email of your Microsoft account. 

Now if everything is good, the moment you click on down arrow of, Select the database: you will need to give the password of your Microsoft account.

after that you can select the warehouse and run queries. 

However, the problem was that it keeps asking me to login again and again, I use cache and run workflow for now, maybe i need to fix the connection timeout and retry time to 600 seconds

[CullenJ]

Thanks, this got it working for me on desktop, but I get this error when trying to run on server:

• Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (ToolId: 2)

Any idea what's going wrong there?