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