Forum Discussion
Solved
Excel connected to sql server
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...
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.
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.