Notifications
Clear all
Topic starter
25/02/2021 11:02 am
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.
and
Topic starter
25/02/2021 11:06 am
This problem occurs in Excel 2016.
1. Go to PowerPivot – Get External Data – From Database – From SQL Server
2. In the Connect to a Microsoft SQL Server Database window, add Server Name, SQL Authentication, Password and the Database Name.
3. Then, click ADVANCED.
4. Set Persist Security Info to false.
This will fix the problem.
Watch our video here: https://youtu.be/n-LDK55BEeA