4] Power BI: Connection to SQL Server from Excel failed When trying to import tables or data from SQL Server into Power BI, we are able to connect to SQL, but when trying to access the database ...

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

To test a SQL database connection, you'll need at least four pieces of information: the user name password, database name and endpoint (such as a DNS name or IP address). For this article, we're only ...

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.

Please note that Integrated Security=false was set in the connection string used above, as the example uses SQL Server Authentication. If Windows Authentication is used, this must be adapted.