none
Authorization for access to Azure Data Lake from Excel

    Question

  • Hello

     

    I am developing an Azure data lake and I want to connect Excel to the data lake.

     

    1. How do you authorize users too see the data from Excel?

    I have used two test users and given them different access to the resource group, the services etc, and they just don't get access. Only I, myself have access.

     

    2. Is it possible to restrict the access so that excel can only see one specific folder in the data lake?

    The normal way to do this is using an app registration, but I can not see how to connect an app to excel.

    Friday, August 31, 2018 8:25 AM

All replies

  • Can you please let us know what different access you tried?
    Friday, August 31, 2018 4:50 PM
    Moderator
  • Hello,

    Are you adhering to the permissions model as described here:

    https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-access-control#common-scenarios-related-to-permissions

    Are your users in AAD?

    It should be possible using this permissions model to a user can only see a specific folder you give them access to with Excel.

    Wednesday, September 5, 2018 1:18 AM
    Moderator