Connect to azure analyse service

[karn]

i try to connect PivotGrid to my model create on Azure analyse service.

 

<telerik:RadPivotGrid ID="RadPivotGrid1" runat="server"
    RenderMode="Lightweight" AllowSorting="True" FieldsPopupSettings-AggregateFieldsMinCount="2" AllowPaging="True"
    PageSize="20"  EnableConfigurationPanel="True" EnableZoneContextMenu="True"
    AggregatesPosition="Rows" Culture="fr-FR"

    >
    <OlapSettings ProviderType="Adomd" AdomdConnectionSettings-ConnectionString=""  >
        <AdomdConnectionSettings Cube="TabularProject2" DataBase="myanalyse"
            ConnectionString="Provider=MSOLAP;Data Source=asazure://westeurope.asazure.windows.net/myanalyse;Initial Catalog=analyseservicedatabase;User ID=xxxxxxxxx;Password=xxxxxxx;Persist Security Info=True;Impersonation Level=Impersonate"></AdomdConnectionSettings>
    </OlapSettings>

    <ConfigurationPanelSettings Position="Left" LayoutType="OneByFour" DefaultDeferedLayoutUpdate="true" />
    <ClientSettings>
        <Scrolling AllowVerticalScroll="false" ScrollHeight="600px" />
    </ClientSettings>
</telerik:RadPivotGrid>

 

but that not work, Pivot Grid is displayed without any data and i have no error.

Any idea ?

 

[karn]

Nobody has any idea ?
My problem is that I do not even have an error for debugging.

[Eyup]

Hi Karn,

Please note that in order to bind to OLAP you need to have the Microsoft.Analysis Services dll assemblies as mentioned here:
https://docs.telerik.com/devtools/aspnet-ajax/controls/pivotgrid/data-binding/radpivotgrid-olap-support.html

You can download our live demos packaged and check this sample:
https://demos.telerik.com/aspnet-ajax/pivotgrid/examples/firstlook/defaultcs.aspx

Here is how you can download them:
https://www.telerik.com/forums/demo-download#K8uyr-vk2kiUZjTePXOjgg

I hope this will prove helpful.

Regards,
Eyup
Progress Telerik

[karn]

Hi Eyup

Thank for you help.

I have the dll and when i change the connection string with the one on this page it works :

https://demos.telerik.com/aspnet-ajax/pivotgrid/examples/olap/defaultcs.aspx

But with the connection string of azure that not work and no error show (the pivot grid is empty).

(the connection work with Excel and PowerBI)

PivotGrid can work with Azure Analysis Service ?

[Eyup]

Hello Karn,

Generally, this scenario is not tested and third party integration is beyond our support scope. But essentially, RadPivotGrid should be properly bound to data which is accessible regardless whether it is coming from Azure, Oracle, AWS, Stored Procedure, etc.

To resolve this, you can try to set some specific credentials as demonstrated in this article:
https://docs.telerik.com/devtools/aspnet-ajax/controls/pivotgrid/data-binding/radpivotgrid-olap-support.html

If this does not work, please ensure with some code-behind C# logic that the data you are trying to fetch from Azure is accessible in your application. For instance, you can display some field value from the first record to an asp:Label on the page to verify that.

Regards,
Eyup
Progress Telerik