Forum Discussion

James Colon's avatar
James Colon
Copper Contributor
Jul 06, 2018

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.

     

Resources