SSAS Tabular OLE DB or ODBC error : The Microsoft Access database engine cannot open or write to the file. It is already opened exclusively by another user, or you need permission to view and write it's data.; 3051.
Hi all, i'm trying to import a spreadsheet into a tabular model and getting this stupid error even though the impersonation account i'm using is an admin account with full access to the file. ANY IDEAS? I hate these stupid permission related issues!!! Thanks for your help.
I found the problem. SSAS uses the service account to first access the file regardless of what impersonation information you use. Make sure the account running SSAS can access the file. Check your SQL config manager to find this information!