You can translate the question and the replies:

unable to connect local instance of denodo to azure analysis service

i have an azure account and i am trying to connect azure analysis service to denodo. it gives me a strange error: Unable to connect to the multidimensional server: unknown protocol: asazure I am able to connect my local SSMS and power bi to the azure analysis service,but cant connect denodo to azure analysis service
user
04-02-2022 05:34:50 -0500
code

3 Answers

Hi, I believe you are accessing Azure Analysis Service from Denodo Platform using HTTP Basic authentication mechanism and that is the reason, you are facing this error “*unknown protocol: asazure*”.Azure Analysis Service does not support HTTP Basic authentication mechanism but a different HTTP based mechanism called “*asazure protocol*” . In order to resolve this error, you should create the Azure Analysis service as a multi dimensional data source with “*Azure Analysis Services*” as the database adapter. Ensure to provide the following details while creating the data source. * URI = The https URI. For example https://westeurope.asazure.windows.net * XMLA URI = The XMLA endpoint. By default, this is URI/webapi/xml by default * Server Name = The Azure Analysis Services server name. * Client ID = The client id of the application registered on Azure for Denodo. * Tenant ID = The tenant id of the application registered on Azure for Denodo. * Client secret = Non-expired client secret of the application registered on Azure for Denodo. For more information, you can refer to the [Multidimensional Database Sources section](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/multidimensional_database_sources/multidimensional_database_sources#multidimensional-database-sources) of Virtual DataPort Administration Guide for creating the data source. Hope this helps!
Denodo Team
07-02-2022 04:36:42 -0500
code
i am still unable to access my cube from denodo. gives me the following error Unable to connect to the multidimensional server: This connection encountered an exception while executing a query
user
08-02-2022 07:56:48 -0500
Hi, This error would occur if the Denodo server is unable to connect to the Azure Analysis Service. I would do the following to resolve this. * Check whether Denodo user account has administrative access and enough privileges to access Azure analysis service. * Ensure that there is no firewall or proxy related setting blocking the connection to Azure analysis service. * Check the VDP logs for detailed error to understand the root cause of the issue. Hope this helps!
Denodo Team
09-02-2022 06:35:33 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here