SOLVED
Home

Excel connected to sql server

%3CLINGO-SUB%20id%3D%22lingo-sub-667185%22%20slang%3D%22en-US%22%3EExcel%20connected%20to%20sql%20server%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-667185%22%20slang%3D%22en-US%22%3EHelp.%3CBR%20%2F%3EI%20have%20an%20excel%20spreadsheet%2C%20summarising%20data%20from%20Sql%20Server%20tables%20through%20power%20query%3CBR%20%2F%3EOthers%20need%20to%20access%20to%20view%20and%20be%20able%20to%20change%20pivots%2C%20selections%20etc.%3CBR%20%2F%3EI%20have%20given%20them%20all%20read%20permissions%20but%20will%3CBR%20%2F%3EThey%20need%20to%20enter%20credentials%20every%20time%20the%20open%20the%20file%3F%3CBR%20%2F%3EI%20am%20running%20a%20batch%20in%20the%20morning%20to%20open%20and%20update%20the%20data%20so%20when%20they%20open%20it%E2%80%99s%20quick%20and%20easy%20for%20them%20but%20don%E2%80%99t%20want%20to%20make%20them%20connect%20each%20time%20they%20view%20the%20file.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-667185%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Epowerquery%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-667246%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20connected%20to%20sql%20server%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-667246%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F354290%22%20target%3D%22_blank%22%3E%40IMO_Data%3C%2FA%3E%26nbsp%3B%2C%20credentials%20are%20required%20only%20once%2C%20but%20for%20each%20user%20who%20runs%20the%20file%20-%20if%20you%20use%20Windows%20authentication.%20Alternatively%20you%20may%20connect%20to%20SQL%20server%20with%20database%20user%20using%20SQL%20server%26nbsp%3Bauthentication.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-719456%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20connected%20to%20sql%20server%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-719456%22%20slang%3D%22en-US%22%3EMany%20thanks.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
IMO_Data
New Contributor
Help.
I have an excel spreadsheet, summarising data from Sql Server tables through power query
Others need to access to view and be able to change pivots, selections etc.
I have given them all read permissions but will
They need to enter credentials every time the open the file?
I am running a batch in the morning to open and update the data so when they open it’s quick and easy for them but don’t want to make them connect each time they view the file.
2 Replies
Solution

@IMO_Data , credentials are required only once, but for each user who runs the file - if you use Windows authentication. Alternatively you may connect to SQL server with database user using SQL server authentication.

Many thanks.
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies