I'm new to Qlik Sense and wanted to connect to some of my data, all of which is in SQL Azure.
The SQL Server data provider refuses to connect to SQL Azure although I can connect via SSMS. I get "Client unable to establish connection" and that I should check my credentials. I'm pretty sure they are correct though.
I also can't connect via ODBC and I don't really understand the ODBC dialog that pops up when I choose this kind of data source (shouldn't I be able to enter a connection string?).
What's the preferred way to connect to SQL Azure? It's not listed as a separate data source option.