0

We have a managed Azure SQL instance, and trying to leverage it for some Azure AS documentation. Managed Azure supports OPENROWSET which was going to be used to access DMVs in the SSAS tabular model, but instead we get the following error:

Msg 7403, Level 16, State 1, Line 1
The OLE DB provider "MSOLAP" has not been registered.

Question is then, can MSOLAP OLE DB provider be installed on an Azure Managed SQL database, and if so how? Thanks!

Example query run on the managed instance:

SELECT *
    FROM OPENROWSET('MSOLAP','DATASOURCE=azure.windows.net/server;
     Initial Catalog=DataCatalog;',
    'SELECT * FROM $SYSTEM.MDSCHEMA_DIMENSIONS')

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.