I setup SSAS Tabular project, it connector local SQL server(AdventureWorksDW db) OK, but if import table, and after loading. Import metadata should be success. but loading table failure, it will appear error that "无法将修改保存到服务器。返回的错误:“OLE DB 或 ODBC 错误 : 抱歉，计算时出错 Condition: sql server2019/VS2019/SSMS v18 How to to resolve it?

Hi @Andrew Lu , Are you trying to follow this tutorial to learn SSAS and stop in Step2: Add data? And are you using On-Premise SQL Server database? If yes, please try to recreate a tabular project and set the Compatibility level to SQL Server 2016 RTM(1200), and then don't select all the table, just select one table for testing. If there is no error, you could start to import all table. Best regards, Carrin If the answer is helpful, please click " Accept Answer " and upvote it. Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Hello, I'm facing the same problem as well, did you found a solution?

the same problem occurred to me, any update ?

same problem occurred to me, any updates?

Deploy SSAS Tabular Model to Server eoor-"OLE DB or ODBC error"

Accepted answer

CarrinWu-MSFT 6,851 Reputation points

2021-08-27T01:48:43.593+00:00

Hi @Andrew Lu ,

Are you trying to follow this tutorial to learn SSAS and stop in Step2: Add data? And are you using On-Premise SQL Server database? If yes, please try to recreate a tabular project and set the Compatibility level to SQL Server 2016 RTM(1200), and then don't select all the table, just select one table for testing. If there is no error, you could start to import all table.

Best regards,
Carrin

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Andrew Lu 116 Reputation points

2021-08-28T15:20:04.183+00:00

you meanings:

Analysis service instance should select Integrated workspace, not selected workspace server.

Compatibility level should selected Sql server 2016 (1200), not selected sql server 2019(1400).

Before I have try to import single table, but it still error happaned.

Thank you reply! I try to do!

Andrew Lu 116 Reputation points

2021-08-28T15:42:19.27+00:00

I try to you said solution, it still error, error displayL
"Failed to save modifications to the server. Error returned: 'The datasource, 'SqlServer Andrew AdventureWorksDW', contains an ImpersonationMode that is not supported for processing operations.

A connection could not be made to the data source with the Name of 'SqlServer Andrew AdventureWorksDW'."

Andrew Lu 116 Reputation points

2021-08-28T16:18:19.61+00:00

Thank you! only change analysis service instance-integrated workspace, compatibility level still 1400.
it is successful!

Andrew Lu 116 Reputation points

2021-08-29T15:55:30.7+00:00

Other process is OK, but last step deploy still fail. how to do?

CarrinWu-MSFT 6,851 Reputation points

2021-08-30T02:02:03.64+00:00

Hi @Andrew Lu , sorry for the late reply. We are normally using Integrated workspace. Because use this setting when creating a project that can be deployed to Azure Analysis Services. Please refer to Workspace database to get more information.

And please check that which is your data source? If the data source is on premise SQL Server database, please refer to Lesson 2: Add Data to get the steps. If the data source is Azure SQL, please refer to Get data to get the steps.

For the latest error, please check that the version of Visual studio code. Please refer to this thread.

Andrew Lu 116 Reputation points

2021-09-01T15:00:39.917+00:00

I want deploy SSAS in local database, it should select workspace database?
but if I select workspace database, after connect solution, and import table to project, it appear ""OLE DB or ODBC error".
If it should select compatibility level 1200?

Andrew Lu 116 Reputation points

2021-09-02T14:52:08+00:00

I select workspace database, and select compatibility level 1200.
and import table from database(MSSQL local), it appear error "Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: The SELECT permission was denied on the object 'DimReseller', database 'AdventureWorksDW', schema 'dbo'.; 42000."

'.
Sign in to comment

Deploy SSAS Tabular Model to Server eoor-"OLE DB or ODBC error"

3 additional answers