14 Replies Latest reply: Sep 7, 2017 11:25 AM by Marc Greenberg RSS

    QlikSense connectivity to SSAS

    Colette de Courcey

      Hi,

       

      I have been struggling to load data into QlikSense (v2.2) from a SQL Services Analysis cube. I'm wondering if anyone has success with this?

       

      I've tried creating an OLE DB data connection, selecting one of the following drivers (against both SSAS 2008R2 and 2012):

      • Microsoft OLE DB Provider for Analysis Services 10.0
      • Microsoft OLE DB Provider for Analysis Services 11.0

       

      The test connection succeeds in each case and I can load and select my 'database' - in this case a cube.

       

      I am presented with a list of 'tables' in my cube and I can see the column names if I select a table from the list. However if I try to preview or load the data I get the following error:

       

      Error.PNG

      Any suggestions on how I can get this to work?

       

      Thanks!