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.

Convert json file to excel