Forum Discussion
Bring data from MSSQL View
Hello, How might one go about loading data from a MSSQL database <VIEW> into Excel? I see how to load table data, but want to preserve permissions/ access to data and of course a pre compiled query...
Hello,
have a look at Power Query (called Get & Transform in Excel 2016). You can create a connection to a SQL database and access a view. You will need to provide the credentials to access the SQL database, so anything that is visible for that account will be available to Power Query.