Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Azure SQL connect to database show system tables not user created?

Somar
5 - Atom

Hi, i was able to connect to Azure SQL using ODBC. I use Power BI and when connected to same server,  i see the database - but not in Alterxy? I see Azure SQL system files but not the database/tables which i created.

 

 

PBI.JPG

 

alterxy.JPG

2 REPLIES 2
jdunkerley79
ACE Emeritus
ACE Emeritus

Try using the OleDB instead of the ODBC:

 

Azure OleDb.jpg

 

I can all the experience I would expect from the SQL design experience:

Azure OleDb 2.jpg

Somar
5 - Atom

Thanks @

 

I tried your recommendation, the connection was failing. I downloaded the ODBC Driver 13 for SQL Server and was succesful, now i can see the database. With the older ODBC driver i was not able to see the database.

Labels
Top Solution Authors