Fabric Lakehouse Shortcut to ADLS Gen2 Storage Not Working

[awbanksh]

When I try to create a shortcut in Fabric Lakehouse I get the below permissions error. I’ve modified the path a few different ways and still get the same error. 

Strangely, i'm able to connect to the ADLS Gen2 path through Data Factory, Dataflow Gen2, Power Query, etc.

Me successfully connecting to ADLS Gen2 through Fabric - Data Factory:

Fabric Lakehouse Shortcut screen:

Fabric Lakehouse Shortcut error: 

[awbanksh]

I got storage reader access and now it's working, thank you!

[awbanksh]

My question was regarding the need for Storage Blob Reader role. I'm able to view and consume .parquet files from ADLS Gen2 without this level of access. 

[Anonymous]

Hi @awbanksh ,

Can you please confirm did you successfully run the copy data activity in the pipeline and able to load the data into Lakehouse?

I would also like to understand what type of access level (role) are you holding for the container consisting the parquet files.

[awbanksh]

I'm still waiting on storage reader access. 

[Anonymous · Accepted solution]

Hi @awbanksh ,

Thanks for you response. Your issue will be resolved once you get Storage Reader Access.

[Anonymous]

Hi @awbanksh ,

Apologies for the delay in reply from our side .

I was able to read the data from ADLS Gen2 using Shortcut.

Role Used: Storage Blob Data reader.
Created Tenant Id, Service Principal Id and Service Principal Key.
ADLS Gen2 Endpoint: Data Lake Storage - Primary End Point.

Data is stored in form of .parquet in ADLS Gen2

Created Shortcut connection in Fabric using Service Principal and was able to read the data.

I cannot find any issue while reading the data.

[awbanksh]

The authentication method is the same as Dataflow Gen2, I'm connecting through a service principal (SA).

I have been give standard level access to the folder path. 

However, I don't believe I have Storage Blob Data Reader role on the storage account.

If I'm able to consume the .parquet files via Dataflow Gen2 doesn't that mean I have Storage Blob Data reader role on the storage account?

[Anonymous]

Hi @awbanksh ,

As I tried repro your scenario, I am able to connect successfully to shortcut and preview my data from ADLS Gen2 to Lakehouse.

Can you please check and confirm with Role and Permissions given to your ADLS Gen 2?

I would like to know which authentication method have used while creating shortcut?

I can you see were able to connect using Data Flow Gen2 successfully and load the data. Did you followed the same steps, i.e. authentication method while connecting with shortcut?