Share via

OLE DB or ODBC error: Error when Processing Tables in Tabluar Model Explorer

Seraj, Amir 1 Reputation point
2022-07-15T14:56:29.347+00:00

When I'm in a the .bim in the Tabular Model Explorer, select a table, and try to process it, I keep getting the error "Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: We're sorry, an error occurred during evaluation.." in the Data Processing screen. Even if I select one table, it will not let me process. I have the same issue importing tables from a data source into the .bim.

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,285 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,591 Reputation points
    2022-07-18T03:59:17.39+00:00

    Hi @Seraj, Amir ,
    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.
    221649-image.png
    221724-image.png
    221725-image.png
    Best Regards,
    Joy

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.