This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 34%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAL%3C/text%3E%3C/svg%3E)
I want to to setup Tabular model for SSAS, but import sqlserver data wrong happened, it can connect sqlserver, but can't import to SSAS.
wrong picture is blow:
how to do next?
Hi @Andrew Lu , welcome to Microsoft Q&A! Could you please click the “错误详细..." to get more error details? And also please share some information as below:
Hi @Andrew Lu , we have not received any reply from you, any update for this thread? Please feel free to let us know if there have any other issues.
SQL sever: 2019 Enterprise
Visual Studio: 2019
Compatibility Level: 1500
Hi @Andrew Lu , thank you for your replying. What about the error details? Could you reproduce it?
Error detail:
OLE DB or ODBC error: We're sorry, an error occurred during evaluation.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 77%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
The third column on your second screenshot, click on one of those links and what does it say?
Hi @Andrew Lu ,
Welcome to Microsoft Q&A!
I saw you snapshot, are you follow the Adventure Works Internet Sales tutorial (1200) to get star with SSAS? If yes, please change the Compatibility level to SQL Server 2016 RTM (1200) when you create a project, and then use administrator role to connect data source.
Please feel free to let me konw it work or not.
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.