It turns out that the restriction on using your own connection string properties in the built-in SQL Server connector is a deliberate design decision on the part of the Power Query team because, ...

Below is a cheat sheet for creating SQL Server client connection strings and finding them in common configuration files. Connecting to instances by name, forcing a named pipes connection.

SQL Server Profiler wants to connect to an instance of Analysis Services; XMLA Endpoints mean that you can connect it to a dataset in a Power BI Premium workspace but for this to happen you need to ...

Change data source connection strings using APIs in PowerShell - Power BI Report Server. Create a SQL Server connection to a server. In the example below, we're connecting to the localhost to a ...

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 ...

We recently added support for Active Directory authentication in the SQL Server connector. This has been one of the most requested feedback from our customers. In this post, I want to give an overview ...

In February we passed 300 connectors -- including the new SAP ERP connector. Since then, we've added 15 new connectors from many different partners. Moreover, you can use Azure AD authentication for ...

When creating automation scripts to discover, add, update or remove records from a remote SQL database, you need to make sure your script can successfully connect to the database.