It may not be immediately obvious, but you cannot set your own connection string properties when connecting to SQL Server using the built-in SQL Server connector from either Power BI or a modern da… ...

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

Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools. To provide an example using real source, I created a simple Winforms ...

CData JDBC Driver connects to Power BI XMLA by exposing them as relational SQL models. This server wraps that driver and makes Power BI XMLA data available through a simple MCP interface, so LLMs can ...

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

We have our SQL server configured to only allow Windows accounts (i.e. not mixed). However, in some cases we are connecting from non-domain boxes and we want to specify a domain account to connect ...

The SQL Server connection using Azure AD authentication is not implicitly shared when a Power App is shared. This is similar to how authentication works for Office 365 Outlook, SharePoint and other ...