In the File Name box, revise the default file name as needed (optional).Ĭlick Browse to change the default file location of My Data Sources, or check for existing file names. Its titled Save Data Connection File and Finish. In the Select the database that contains the data you want box, select a database, and then click Next.Ĭlick Next to go to the third wizard screen. To connect to a specific cube file in the database, make sure that Connect to a specific cube or table is selected, and then select a cube from the list. Select Next to go to the second wizard screen. Store the passwords that you write down in a secure place away from the information that they help protect. If you forget your password, Microsoft cannot retrieve it. It is critical that you remember your password. A pass phrase that uses 14 or more characters is better. Passwords should contain 8 or more characters. For example, Y6dh!et5 is a strong password and House27 is a weak password. Use strong passwords that combine uppercase and lowercase letters, numbers, and symbols. To enter a database user name and password, click Use the following User Name and Password, and then type your user name and password in the corresponding User Name and Password boxes. To use your current Windows user name and password, click Use Windows Authentication. Under Log on credentials, do one of the following, then click Next: Tip: If you know the name of the offline cube file that you want to connect to, you can type the complete file path, file name, and extension. Click OK in the message to connect using an unencrypted connection.įor more information about advanced connector options, see SQL Server database (). If a connection to your SQL Server is not established using an encrypted connection, Power Query prompts you to connect using an unencrypted connection. If you do not want to connect using an encrypted connection, clear this check box, and then click Connect. After you select this, specify a user name and password to connect to your SQL Server instance.īy default, the Encrypt connection check box is selected to signify that Power Query connects to your database using an encrypted connection. Select this if you want to connect using Windows authentication.ĭatabase Select this if you want to connect using SQL Server authentication.
Select the authentication mode to connect to the SQL Server database.
For more information, see Import Data from Database using Native Database Query. If you want to import data using a native database query, specify your query in the SQL Statement box. Optionally, you can specify a Database Name as well. In the Microsoft SQL Database dialog box, specify the SQL Server to connect to in the Server Name box.
Select Data > Get Data > From Database > From SQL Server Database.
0 kommentar(er)
