When I am looking at

Here is the question: How do I connect to my Gen 2 datalake with Azure AD / OAuth / username ([email protected]) and password? Storage Account Key Access is disabled on this datalake. That includes Shared key and shared access signature (SAS)

CodePudding user response：

I can see only a UI connector for ADLS Gen1

Alternately for ADLS Gen2....

Here is something I tried, you can use user delegation SAS Key, which is secured with Azure AD credentials.

1. Generate a user delegation SAS url for that blob you want to access.

2. Select Web Source to get Data,

3. If prompted, select Anonymous

CodePudding user response：

First I want to thank KarthikBhyresh-MT for his input that inspired me to find the right solution.

The Solution First I found the url to the desired file inside the datalake inside azure portal

I copied the changed the url and changed the word blob to dfs

In excel (office 365) I Get Data > From Web, and put in the altered url. From there I get this image, where I can log into the datalake with OAuth credentials

Then I could load the simple.csv file into excel, work on it and see the transactions in the datalake logs.