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

Andrew Lu 116 Reputation points
2021-08-26T15:01:19.587+00:00

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
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,256 questions
0 comments No comments
{count} votes

Accepted answer
  1. CarrinWu-MSFT 6,866 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.

    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.


3 additional answers

Sort by: Most helpful
  1. Abdelhak Ohammou 6 Reputation points
    2022-01-06T14:51:08.517+00:00

    Hello,

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

    1 person found this answer helpful.
    0 comments No comments

  2. weiyang yue 1 Reputation point
    2022-07-26T01:57:32.503+00:00

    the same problem occurred to me, any update ?

    0 comments No comments

  3. aya asfour 1 Reputation point
    2022-10-30T17:49:32.59+00:00

    same problem occurred to me, any updates?

    0 comments No comments