OLAP Connection to Azure Analysis Services

[Josh Hulbert]

Is it possible to connect to Azure Analysis Services with the Blazor PivotTable control? I started with the demo https://blazor.syncfusion.com/demos/pivot-table/olap?_ga=2.185279200.81435417.1604808498-554190269.1603832703 and changed the connection info to use the URL provided by Azure with the server value in the form of: 

asazure://eastus.asazure.windows.net/instancename.

I get a few errors in the browser console - but the significant ones appear to be:

Access to XMLHttpRequest at 'address to my AAS instance' from origin 'http://localhost:52421' has been blocked by CORS policy: Cross origin requests are only supported for protocol schemes: http, data, chrome, chrome-extension, chrome-untrusted, https.

The URL they provide does start with asaazure:// which obviously is not in that list. 

[Saranya Sivan]

Hi Josh, 

  

We will update the details shortly. 

 

Regards, 

Saranya Sivan. 

[Manikandan Murugesan]

Hi Josh, 

 

Could you please ensure the cube by hosting it in locally (local host) as mentioned in the following blog? 

 

https://docs.microsoft.com/en-us/analysis-services/instances/configure-http-access-to-analysis-services-on-iis-8-0?view=asallproducts-allversions 

 

Please let us know if any concerns. 

 

Regards, 

Manikandan. 

[Ernesto]

Hello

I am also interest in connecting the Pivot Table to an Azure Analysis Services Tabular Model. Is it possible?

Thanks!

[AngelinFaithSheeba PaulvannanRajadurai]

Hi Josh,

We would like to inform you that based on the current architecture, our Syncfusion Pivot Table only supports connecting the SSAS OLAP cube. Therefore, our Syncfusion Pivot Table will not support the hosted URL established with the Azure Analysis service.

Please let us know if you have any concerns.

Regards,

Angelin Faith Sheeba.