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.

Microsoft Azure Data Lake Store - Issue connecting to azure datalake

anoopbr
5 - Atom

I am new to Alteryx. My requirement is to access csv files on Azure datalake on Alteryx and run a data manipulation program. 

I am using the Alteryx connector ( https://help.alteryx.com/20213/designer/microsoft-azure-data-lake-store ). I am using the End-User (Advanced) option.
The Office 365 team has created a Service principal (and provided me the TenantId, clientId and secret) to allow access to the Azure data lake. The admins of azure datalake have confirmed that the service principal should have the required access. However when i try connecting the Azure datalake, i am asked to verify the credentials and then after completing that i get an Invalid resource error (AADSTS650057). Any idea where this might be going wrong?

1 REPLY 1
apathetichell
20 - Arcturus

I believe that message is saying the client id for the app (as in Alteryx) doesn't have permission for that section of ADLS.  The section of https://help.alteryx.com/20213/designer/microsoft-azure-data-lake-store describing basic authorization provides the Alteryx client app IDs. Can you check to see if those need to be enabled as well? Perhaps you can try the basic set up to see if that works?

Labels
Top Solution Authors