Share via

Import sqlsever data into SSAS wrong hapened? how to do?

Andrew Lu 1 Reputation point
2021-07-23T15:46:04.593+00:00

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:
117420-%E6%8D%95%E8%8E%B7.png
117469-wrong.png

how to do next?

SQL Server Integration Services
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.

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CarrinWu-MSFT 6,891 Reputation points
    2021-07-30T01:45:54.12+00:00

    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.

    Was this answer helpful?

    0 comments
  2. Ryan Abbey 1,186 Reputation points
    2021-07-25T19:57:12.067+00:00

    The third column on your second screenshot, click on one of those links and what does it say?

    Was this answer helpful?

    0 comments

Your answer

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