Microsoft 365 Power Platform Troubleshooting

Connecting SQL Server Express to Power BI using SQL Server authentication

Databases are created, SQL Server DB user is created and assigned rights to the AdventureWorks DB, SQL Server services are up and running, TCP/IP is enabled, but Power BI still will not connect with SQL Server Express unless you use Windows authentication