[Solved] PowerPivot in Excel 2016: OLE DB or ODBC error. Login failed for user
When I try to get data in the table import wizard into PowerPivot, I get the message: OLE DB or ODBC error. Login failed for user ‘mike.farmer’.; 28000. A connection could not be made to the data source.
This problem occurs in Excel 2016.
This will fix the problem.
Watch our video here: https://youtu.be/n-LDK55BEeA