Example of connecting to an SQL table

Dashboard Designer SharePoint 2013/2016, Office 365 versions
1

Hi,

Is there an example of where I can connect directly to a SQL table as a data source. I have the server name, login credentials, and table info.

Thanks.

2

Hi,

First, you need to configure BCS connection to your SQL database:
https://msdn.microsoft.com/en-us/library/office/jj163782.aspx

Then use the external list as any other list in Dashboard Designer.