Logging to an Azure SQL server
In the vast majority of companies, business information is persisted in a Relational Database Management System (RDBMS). Microsoft's quintessential relational database is SQL Server in its on-premises version if the company adopts the Microsoft data platform. Otherwise it is Azure SQL Server, which is a Platform as a Service (PaaS), cloud-hosted database.
Generally, it is a good idea to centralize all of a company's key information in a single repository. That's why it might be useful to know how to log information from within a Power BI process into a SQL Server database or an Azure SQL database.
If you have the option to already access an instance of SQL Server on-premises or Azure SQL Server, you just need to make sure that ODBC Driver for SQL Server is installed on your machine. In fact, both Python and R will connect to (Azure) SQL Server via an ODBC connection. You have the option to install the driver on your machine directly...
