Connect to azure analyse service

5 posts, 0 answers
  1. karn
    karn avatar
    15 posts
    Member since:
    Feb 2010

    Posted 02 Aug 2018 Link to this post

    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 ?

     

  2. karn
    karn avatar
    15 posts
    Member since:
    Feb 2010

    Posted 06 Aug 2018 in reply to karn Link to this post

    Nobody has any idea ?
    My problem is that I do not even have an error for debugging.
  3. Eyup
    Admin
    Eyup avatar
    3786 posts

    Posted 07 Aug 2018 Link to this post

    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
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
  4. karn
    karn avatar
    15 posts
    Member since:
    Feb 2010

    Posted 07 Aug 2018 in reply to Eyup Link to this post

    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 ?

  5. Eyup
    Admin
    Eyup avatar
    3786 posts

    Posted 10 Aug 2018 Link to this post

    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
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Back to Top