When trying to import tables or data from SQL Server into Power BI, we are able to connect to SQL, but when trying to access the database, it says that the connection failed. We get the following ...

The Connection Properties dialog opens. For my sample ITworld application, I changed the data source to Microsoft SQL Server (SQLClient), and entered the necessary Server, Log On, and database values.