Forum Discussion
James Colon
Jul 06, 2018Copper Contributor
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 ie my database table View.
Thoughts?
Thanks!
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.