Fix an Excel Database Driver Error Connecting to Azure Analysis Services
Question details
Determine why Excel cannot connect to Azure Analysis Services on a corporate Office image when the same connection works on a clean Office installation.

- Product
- Microsoft Excel and Azure Analysis Services
- Device & OS
- not provided
- Scenario
- A user connects Excel to an Azure Analysis Services database from computers with a corporate Office image.
- Observed behavior
- Excel reports a database driver error on the corporate image, while the connection works on a clean Office installation.
Record the exact error message and the Azure Analysis Services server address. Make sure you can compare the failing computer with the working installation, and involve your IT administrator before changing managed software or settings.
Compare the Corporate Office Image With the Working Installation
Use the working installation as a baseline to identify differences in Excel, drivers, and connection settings.
In Excel on both computers, open File > Account > About Excel and record the Office version, build, and 32-bit or 64-bit architecture.
Open the installed apps list on each computer and compare Microsoft Analysis Services client components, including the MSOLAP provider. Ask IT to verify that the required provider version is installed and compatible with the Office deployment.
In Excel, open Data > Queries & Connections and inspect the connection properties on both computers. Compare the server address, database, provider, and authentication settings without sharing credentials.
Ask IT to correct any confirmed provider or configuration differences, then open the workbook in Excel and use Data > Refresh All to test the connection again.

Escalate the Connection Error to Microsoft or Your IT Team
Use this route if comparing installations does not reveal the cause or if managed policies prevent changes.
Work With Excel Files in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheet files. It can help you move everyday workbook tasks across office suites, but it does not fix Excel's Azure Analysis Services driver error.

Frequently Asked Questions
Why does the connection work on a clean Office installation?
The installations may differ in their Office build, architecture, Analysis Services provider, connection settings, or enterprise policies. Compare File > Account > About Excel, installed client components, and the connection properties to narrow down the difference.
Where can I check whether Excel is 32-bit or 64-bit?
Open Excel and select File > Account > About Excel. The dialog shows the Office version and architecture.
Which driver should I compare between the two computers?
Compare the installed Microsoft Analysis Services client components, particularly the MSOLAP provider, and ask your IT administrator to check that the required version is compatible with the Office deployment.
Does WPS Office fix the Azure Analysis Services driver error in Excel?
No. WPS Office is an alternative for working with compatible spreadsheet files; the Excel connection error requires troubleshooting the Microsoft Office environment and its Analysis Services components.




