Forum Discussion
Creating a shortcut in lakehouse
I had created shortcut from my ADLS gen2 to fabric it works well , and I used the same shortcut in lakehouse in files section get the data from inputdataset container(contains two csv files) as shown below , but when I load those files into table I am getting error as OneLakeShortcutAuthorizationFailed.
After clicking new table option
and I got below error
Onelake shortcut authorization failed. Make sure there are proper permissions and/or valid token for the storage linked by the shortcut.
activityId : 1893ef23-4eb9-4363-a37b-cbf5d7cec871
errorCode : OneLakeShortcutAuthorizationFailed
httpResponseCode : 403
After selecting the "load" option, in the screenshot that you had given above the data was successfully transformed into tables.
8 Replies
Thank you for using Microsoft Fabric Community.
I tried to repro the scenario and didn't find any difficulty in loading the files into table. For reference please find the screenshot.
A 403 error while accessing ADLS Gen2 in Fabric Lakehouse after creating a shortcut with your credentials indicates an authorization issue. Could you pleaser refer the below links which might help you.
Link 1 : Solved: Fabric Lakehouse Shortcut to ADLS Gen2 Storage Not... - Microsoft Fabric Community
Link 2 : Solved: Not able to connect to ADLS with shortcut in Lakeh... - Microsoft Fabric Community
I hope this information helps. Please do let us know if you have any further queries.
Thank you.
Hi v-cboorla-msft , Thanks for sharing the links , but after going to the above links I have given the role as storage blob reader and storage blob contributor as shown below. and also in networking part I have enabled the public network acces from all network. After doing above all it is giving me the same error.
Apologies for the inconvenience.
Please reach out to our support team to gain deeper insights and explore potential solutions. It's highly recommended that you reach out to our support team. Their expertise will be invaluable in suggesting the most appropriate approach.
Please go ahead and raise a support ticket to reach our support team:
https://support.fabric.microsoft.com/support
After creating a Support ticket please provide the ticket number as it would help us to track for more information.
Thank you.
After selecting the "load" option, in the screenshot that you had given above the data was successfully transformed into tables.
