I got an error that I cannot connect to SQL while demoing olap.Help me repair this error,please.

võ thị tuyết ngân 20 Reputation points
2024-10-02T10:16:50.4933333+00:00

User's image

Please help me fix the following error

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
11,765 questions
Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
7,220 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,049 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
540 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 45,121 Reputation points
    2024-10-02T11:00:29.3633333+00:00

    As the message says.

    You have only an "Excel Destination, but no kind source and so no input columns.

    0 comments No comments

  2. ZoeHui-MSFT 37,976 Reputation points
    2024-10-07T01:45:23.6366667+00:00

    Hi @võ thị tuyết ngân,

    You could not only use the Destination component alone, you need to add a source data before it.

    User's image

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

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.