I am unable to save adjustments to my sql statement in power pivot.
I tried to make adjustments in "Table" then "Table Properties".
The following error comes up when I hit the "Save" button in the "Edit Table Properties" screen:
"OLE DB or ODBC error: Login failed for user 'tester'.; 42000.
A connection could not be made to the data source with the DataSourceID of '685fe4e2-e1ba-47d9-9188-be3ccdb44793', Name of 'SqlServer server1'.
An error occurred while processing table 'Query'.
The current operation was cancelled because another operation in the transaction failed."
Any help very much appreciated. Thanks.
I tried to make adjustments in "Table" then "Table Properties".
The following error comes up when I hit the "Save" button in the "Edit Table Properties" screen:
"OLE DB or ODBC error: Login failed for user 'tester'.; 42000.
A connection could not be made to the data source with the DataSourceID of '685fe4e2-e1ba-47d9-9188-be3ccdb44793', Name of 'SqlServer server1'.
An error occurred while processing table 'Query'.
The current operation was cancelled because another operation in the transaction failed."
Any help very much appreciated. Thanks.
