Copy of Power Query

Authentication Type

1. Microsoft Enrta MFA(Multifactor Authentication)

Input (Required)

• Server - The server name or IP address where the MS-SQL database is hosted.
• DBname - The name of the database to which you want to connect.

          - Optional:

             * MSSQL String

Parameter setting examples(diagrams)

2. SQL Server Authentication

Input (Required)

• Host- The host name or IP address of the MS-SQL server
• User- The username with access to the database
• Password -  the corresponding password for the user
• DBname - the name of the database to which you want to connect
• Port - the port on which the MS-SQL server listens.

        - Optional:

              * MSSQL String

Parameter setting examples(diagrams)

3. Data Input

Input (Required)

• Host/Server- The hostname or server name where MS-SQL is hosted.
• User - The database username
• Password -  PAssword associated with the database user
• DBname - The target database where data will ve imported
• Port - The port MS-SQL server listens required with host.

        - Optional:

              * MSSQL String

Parameter setting examples(diagrams)

Return Value

• Stirng(default)

Return code

• 0 success
• 99 Exceptional caes

Ouput Format

You may choose one of 3 output formats below,

• stirng(default)
• CSV
• File