Accessing Synapse Workspace (Data lake Silver layer)

Created by Andrew Dewell, Modified on Wed, 11 Jun at 11:14 AM by Andrew Dewell

To access Synapse workspace views for analytics for Power Query via Excel use the following credentials.

go to Get Data
select SQL Server database
in Server field enter : epdatasynapse-ondemand.sql.azuresynapse.net
Database enter : epdataserverless

You can then select the Synapse views that are required or use the query field to create a SQL query to select data from all a number of related tables.