If you get this error, first import SQL DB tables to Excel, you need to go to Home > From Other Sources > From SQL Server. Now, you must connect to SQL DB using Windows or SQL Authentication.