Active Directory with Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1690470%22%20slang%3D%22en-US%22%3EActive%20Directory%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1690470%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%3CBR%20%2F%3EI%20have%20a%20number%20of%20queries%20that%20are%20connected%20to%20a%20database%2C%20that%20are%20being%20switched%20over%20to%20active%20directory.%20The%20queries%20are%20on%20a%20shared%20network%20and%20are%20accessed%20by%20a%20number%20of%20users.%20I%20have%20removed%20all%20current%20permissions%20and%20singed%20in%20with%20my%20Microsoft%20Account%20and%20the%20query%20loads%20and%20refreshes.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20I%20then%20close%20and%20save%20the%20file%20and%20another%20user%20opens%20the%20spreadsheet%2C%20how%20does%20the%20Active%20Directory%20sign%20in%20work%3F%20When%20you%20go%20to%20Edit%20Permissions%20in%20Power%20Query%2C%20it%20says%20%E2%80%98you're%20already%20signed%20in'%20but%20it%20doesn't%20say%20who%20you're%20singed%20in%20as.%20Not%20sure%20if%20its%20holding%20the%20last%20person%20who%20logged%20in%3F%20The%20aim%20is%20for%20each%20user%20who%20accesses%20the%20spreadsheet%2C%20to%20be%20logged%20in%20via%20Active%20Directory.%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20advice%20would%20be%20much%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1690470%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1690487%22%20slang%3D%22en-US%22%3ERe%3A%20Active%20Directory%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1690487%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F801086%22%20target%3D%22_blank%22%3E%40Cheryl01%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20takes%20current%20user%20credentials%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi there
I have a number of queries that are connected to a database, that are being switched over to active directory. The queries are on a shared network and are accessed by a number of users. I have removed all current permissions and singed in with my Microsoft Account and the query loads and refreshes.

If I then close and save the file and another user opens the spreadsheet, how does the Active Directory sign in work? When you go to Edit Permissions in Power Query, it says ‘you're already signed in' but it doesn't say who you're singed in as. Not sure if its holding the last person who logged in? The aim is for each user who accesses the spreadsheet, to be logged in via Active Directory.

Any advice would be much appreciated.

4 Replies
Highlighted

@Cheryl01 

It takes current user credentials

Highlighted

Thank you for your reply@Sergei Baklan

 

Upon first access, are they prompted to sign in?

Highlighted

@Cheryl01 

I'm not sure if first sign-in will be required, they already opened Excel with their credentials. Don't remember exactly. What will be required first time that's Run Native query if you use it, but that's just click on Yes.

Highlighted

Thanks again@Sergei Baklan i will see if i can test the first sign in with some users.