Error using an OLAP connection: "The 'MSOLAP' provider is not registered on the local machine..."

This error can occur when trying to run a query while the underlying data source is MS OLAP.

The error indicates that the msolap130.dll file is not registered in the Pyramid environment.

To correct this, open the command prompt as an administrator on each of the Pyramid Windows Connector servers and run the below command:

regsvr32 "C:\Program Files\Microsoft Analysis Services\AS OLEDB\130\msolap130.dll"


regsvr32 "C:\Program Files\Microsoft Analysis Services\AS OLEDB\140\msolap.dll"

*You should use the newest one out of the two above.

*This folder path is created by the Pyramid installer, however, the path might be slightly different on your server so before running the command, confirm that the dll file exists and correct the path in the command if needed. 

In case this does not resolve the issue, please contact Pyramid support