legacy connection in excel file in tableau on mac

When you connect to the data in Power Query, the Power Query navigator creates two lists. For example, consider the following workbook example that contains data from A1 to C5, more data from D8 to E10, and more from C13 to F16. If you connect to an Excel Workbook that doesn't specifically contain a single table, the Power Query navigator will attempt to create a suggested list of tables that you can choose from. In Navigator, select the workbook information you want, and then Transform Data to continue transforming the data in Power Query Editor. If this is the first time you've accessed this Excel workbook, select the authentication kind and sign in to your account (if needed). If necessary, select an on-premises data gateway to access the Excel workbook.

In the Excel dialog box that appears, provide the path to the Excel workbook. To make the connection from Power Query Online: In Navigator, select the workbook information you want, then either select Load to load the data or Transform Data to continue transforming the data in Power Query Editor.Ĭonnect to an Excel workbook from Power Query Online If the Excel workbook is online, use the Web connector to connect to the workbook.

Select the Excel option in the connector selection.īrowse for and select the Excel workbook you want to load. To make the connection from Power Query Desktop:

Capabilities SupportedĬonnect to an Excel workbook from Power Query Desktop So if you're seeing this error in a cloud host (such as Power Query Online), you'll need to use a gateway that has ACE installed to connect to the legacy Excel files. ĪCE can't be installed in cloud service environments. To download the client software, visit the following site. The 32-bit (or 64-bit) version of the Access Database Engine OLEDB provider may be required to read this type of file. The '.12.0' provider is not registered on the local machine. If you don't have it installed, you'll see the following error when connecting to legacy workbooks: To install this provider, go to the download page and install the relevant (32 bit or 64 bit) version. xlsb), the Access Database Engine OLEDB (or ACE) provider is required. To connect to a legacy workbook (such as. Some capabilities may be present in one product but not others due to deployment schedules and host-specific capabilities.

Legacy connection in excel file in tableau on mac