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.

How to get power query in excel 2013