If you are using Windows 8 and want to connect to IBM DB2 using Power Query, you need to follow additional installation steps. There are known issues reported by IBM installing the IBM DB2 Data Server Driver on Windows 8. Select the driver that matches your Power Query installation (32-bit or 64-bit). You can specify how a PivotTable is accessed if the workbook is saved to Excel Services and is opened by using Excel Services.īefore you can connect to an IBM DB2 database, you need the IBM DB2 Data Server Driver installed on your computer (minimum requirement is the IBM Data Server Driver Package (DS Driver)). Selecting this check box ensures that updates to the connection file will always be used by all workbooks that use that connection file. To ensure that the connection file is used when the PivotTable is refreshed, click Always attempt to use this file to refresh this data. In the Description, Friendly Name, and Search Keywords boxes, type a description of the file, a friendly name, and common search words (all are optional). 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |