Microsoft added muscle to Power BI Report Server (PBRS), its on-premises self-service analytics and enterprise reporting solution, in the latest preview release.

This means all current and future Power BI features available in live connection mode with SQL Server Analysis Services are also supported with AtScale.

Next, we'll need to establish a connection to the SQL server. Below I'm defining a SQL connection string and passing that as an argument to the SqlConnection object.