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.
0 kommentar(er)
