question

AndrewLu81 avatar image
0 Votes"
AndrewLu81 asked weiyangyue-3113 answered

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

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 错误 : 抱歉,计算时出错

126805-connect-mssql-and-import-table.png


126816-error-display.png



Condition: sql server2019/VS2019/SSMS v18
How to to resolve it?

sql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered AndrewLu81 commented

Hi @AndrewLu81,

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.

126935-1.png
126936-2.png
126944-3.png


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.



1.png (21.4 KiB)
2.png (27.5 KiB)
3.png (17.9 KiB)
· 7
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

you meanings:
1. Analysis service instance should select Integrated workspace, not selected workspace server.
2. Compatibility level should selected Sql server 2016 (1200), not selected sql server 2019(1400).
3. Before I have try to import single table, but it still error happaned.

Thank you reply! I try to do!




0 Votes 0 ·

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'."

127306-01.png127278-02.png


0 Votes 0 ·
01.png (12.4 KiB)
02.png (31.8 KiB)

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

0 Votes 0 ·

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


0 Votes 0 ·
04.jpg (47.1 KiB)

Hi @AndrewLu81, 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.

0 Votes 0 ·

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?

0 Votes 0 ·

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."

128791-05.jpg


'.


0 Votes 0 ·
05.jpg (61.5 KiB)
abdelhak avatar image
1 Vote"
abdelhak answered

Hello,

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

weiyangyue-3113 avatar image
0 Votes"
weiyangyue-3113 answered

the same problem occurred to me, any update ?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.