For more information, see Import Data from Database using Native Database Query.īy default, the Encrypt connection check box is selected so that Power Query connects to your database using a simple encrypted connection. There is a free one-month trial for Office 365. If you want to import data using a native database query, specify your query in the SQL Statement box. The Office 365 bundle includes six apps: Excel, PowerPoint, OneDrive, OneNote, Outlook, and Word, each of which can also be downloaded individually. Optionally, you can specify a Database Name as well. In the Sybase Database dialog box, specify the Sybase Server to connect to in the Server Name box. In the POWER QUERY ribbon tab, select From Database > From Sybase Database.
Select the driver that matches your Power Query installation (32-bit or 64-bit). To learn more, see Get & Transform in Excel 2016.īefore you can connect to an SAP SQL Anywhere database, you need the SAP SQL Anywhere driver installed on your computer. Information provided here applies to both. Get started with Power Map in Excel 2013. Power Map is a 3-D data visualization tool in Excel 2013 and Office 365. If the Filters Area isn’t visible on the right side, on the Power View tab Filters Area. Go to a Power View sheet in the workbook. Power Query is known as Get & Transform in Excel 2016. Open an Excel workbook in a browser window.
