12 Replies Latest reply on Apr 3, 2017 12:20 PM by Mariano Teixeira

    SSAS Cubes and Tableau Desktop

    Lisa Clark

      I am looking to connect Tableau Desktop 10.2.0 (32 bit version) to a local SSAS cube.  Tableau can establish the connection and it can see the associated database, but then I get an error:

       

      "

      • Analysis Services database error 0x80004005: File system error: An error occurred while opening the '//scrsvr.scr.local/[user details]/201415Final_Learner.cub' local cube file.
      • Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.

      "

       

      I have tried:

      • to open the inbound port 2383 (I may have done that incorrectly though) and I am still getting the error.
      • to install the SQL_AS_OLEDB.msi (this refused to run on my system)
      • I used to have the 64-bit version but uninstalled and now have the 32-bit version

       

      I have googled all morning! Can anyone help?

       

      [For info, I can access the cube a number of other ways, so I don't think this is a cube or authentication issue]

        • 1. Re: SSAS Cubes and Tableau Desktop

          Hi Lisa Clark,

           

          Have you tried installing the drivers for the Analysis services?

           

          Drivers & Activation | Tableau Software

           

          ----------

          Lénaïc RIÉDINGER, Global Community Engineer Tableau

          Tableau Community Forums | Knowledge Base

          If you see an Helpful or Correct response, please mark it thanks to the buttons below the targeted post!

          • 2. Re: SSAS Cubes and Tableau Desktop
            Lisa Clark

            yes, I have installed the drivers but I still get the same error.

             

            I can connect directly to the cubes using R:

             

            con[["ConnectionString"]] <- paste("Provider=MSOLAP.5", "Data Source=\\\\servername\\Users\\lisaclark\\Learner.cub", "Persist Security Info=True", sep = ";")

            con$Open()

            • 3. Re: SSAS Cubes and Tableau Desktop
              Rachel Herrera

              Lisa,

               

              I am having the same issue! I am able to connect  my cube to Data Tools, Excel, and SSMS but not Tableau. I have downloaded and uninstalled and downloaded again all of the drivers in the Tableau site but still not dice.

               

              Keep getting the same error as you:

              Download and install the drivers, and then connect.

               

               

              Detailed Error Message:

               

               

              The drivers necessary to connect to this database are not properly installed. Visit http://www.tableau.com/drivers to download driver setup files.

              Database error 0x80040154: Class not registered

              Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.

               

              Very frustrating and hoping someone can help us!!

              • 4. Re: SSAS Cubes and Tableau Desktop
                Mariano Teixeira

                Hi Lisa,

                 

                Are you using Windows Authentication or specific username/password? And is it the same authentication method as when you're connecting with R?

                 

                By the way, which version of the MS SSAS driver have you installed?

                 

                 

                Thanks,

                Mariano

                • 5. Re: SSAS Cubes and Tableau Desktop
                  Lisa Clark

                  Hi Mariano,

                   

                  I am using Windows authentication, as for other software.  I have installed "2014 SP1 (version 12.0.2000.8)" (32 bit versions) and the cubes are generated using MSAS 12.0.5000.0

                   

                  It is a really frustrating issue.

                   

                  lisa

                  • 6. Re: SSAS Cubes and Tableau Desktop
                    Mariano Teixeira

                    Hi Lisa,

                     

                     

                    Is your Tableau Desktop also in 32 bits? For this one, see if running the same architecture helps (both Tableau Desktop and MSAS driver in either 32 or 64 bits).

                     

                    If that doesn't help, could you share Tableau Desktop logs from when you're trying to make the connection?

                     

                    Thanks,

                    Mariano

                    • 7. Re: SSAS Cubes and Tableau Desktop
                      Lisa Clark

                      Hi,

                       

                      I am using 32-bit version of Tableau Desktop and the drivers for 32-bit.  I believe these are needed for access to local cub files.

                       

                      I am not sure how to attach the log file.  The relevant part seems to be:

                       

                       

                      {"ts":"2017-03-22T10:16:22.705","pid":11376,"tid":"1058","sev":"info","req":"-","sess":"-","site":"{3F779924-B975-4D4A-A3E8-6939AF8C4B52}","user":"-","k":"construct-protocol-group","v":{"attributes":{":locale":"","authentication":"sspi","class":"msolap","dbname":"","server":"C:\\Temp\\SheffieldCityRegion_201516Final_Learner.cub"},"closed-protocols-count":"0","connection-limit":"16","group-id":"0","in-construction-count":"0","protocols-count":"0","this":"0x13b66258"}}

                      {"ts":"2017-03-22T10:16:23.069","pid":11376,"tid":"1d10","sev":"warn","req":"-","sess":"-","site":"{3F779924-B975-4D4A-A3E8-6939AF8C4B52}","user":"-","k":"msg","v":"Error retrieving property 0x00000008"}

                      {"ts":"2017-03-22T10:16:23.069","pid":11376,"tid":"1d10","sev":"info","req":"-","sess":"-","site":"{3F779924-B975-4D4A-A3E8-6939AF8C4B52}","user":"-","k":"msg","v":"INFO: Connected via PROVIDER=\"msolap\" to DBMS=\"Analysis Server (12.0.2569.0), Provider Version 12.0.2569.0, OleDB Version 02.60\""}

                      {"ts":"2017-03-22T10:16:23.069","pid":11376,"tid":"1d10","sev":"warn","req":"-","sess":"-","site":"{3F779924-B975-4D4A-A3E8-6939AF8C4B52}","user":"-","k":"msg","v":"Error retrieving property 0x00000008"}

                      {"ts":"2017-03-22T10:16:23.069","pid":11376,"tid":"1d10","sev":"info","req":"-","sess":"-","site":"{3F779924-B975-4D4A-A3E8-6939AF8C4B52}","user":"-","k":"construct-protocol","v":{"attributes":{":locale":"",":thread-session":"0","authentication":"sspi","class":"msolap","dbname":"","server":"C:\\Temp\\SheffieldCityRegion_201516Final_Learner.cub"},"created":"22/03/2017 10:16:22","created-elapsed":0.364,"disconnected":false,"id":0,"this":"0x13b804e8"}}

                      {"ts":"2017-03-22T10:16:23.070","pid":11376,"tid":"1058","sev":"info","req":"-","sess":"-","site":"{3F779924-B975-4D4A-A3E8-6939AF8C4B52}","user":"-","k":"protocol-added-to-group","v":{"group":{"attributes":{":locale":"","authentication":"sspi","class":"msolap","dbname":"","server":"C:\\Temp\\SheffieldCityRegion_201516Final_Learner.cub"},"closed-protocols-count":"0","connection-limit":"16","group-id":"0","in-construction-count":"0","protocols-count":"1","this":"0x13b66258"},"protocol-id":"0"}}

                      {"ts":"2017-03-22T10:16:23.271","pid":11376,"tid":"1058","sev":"info","req":"-","sess":"-","site":"{3F779924-B975-4D4A-A3E8-6939AF8C4B52}","user":"-","k":"destruct-protocol","v":{"attributes":{":locale":"",":thread-session":"0","authentication":"sspi","class":"msolap","dbname":"","server":"C:\\Temp\\SheffieldCityRegion_201516Final_Learner.cub"},"created":"22/03/2017 10:16:22","created-elapsed":0.364,"disconnected":false,"group-id":0,"id":0,"this":"0x13b804e8"}}

                      {"ts":"2017-03-22T10:16:23.272","pid":11376,"tid":"1058","sev":"info","req":"-","sess":"-","site":"{3F779924-B975-4D4A-A3E8-6939AF8C4B52}","user":"-","k":"protocol-removed-from-group","v":{"group":{"attributes":{":locale":"","authentication":"sspi","class":"msolap","dbname":"","server":"C:\\Temp\\SheffieldCityRegion_201516Final_Learner.cub"},"closed-protocols-count":"0","connection-limit":"16","group-id":"0","in-construction-count":"0","protocols-count":"0","this":"0x13b66258"},"protocol-id":"0"}}

                      {"ts":"2017-03-22T10:16:23.273","pid":11376,"tid":"1058","sev":"info","req":"-","sess":"-","site":"{3F779924-B975-4D4A-A3E8-6939AF8C4B52}","user":"-","k":"destruct-protocol-group","v":{"attributes":{":locale":"","authentication":"sspi","class":"msolap","dbname":"","server":"C:\\Temp\\SheffieldCityRegion_201516Final_Learner.cub"},"closed-protocols-count":"0","connection-limit":"16","group-id":"0","in-construction-count":"0","protocols-count":"0","this":"0x13b66258"}}

                      {"ts":"2017-03-22T10:16:23.274","pid":11376,"tid":"1058","sev":"info","req":"-","sess":"-","site":"{3F779924-B975-4D4A-A3E8-6939AF8C4B52}","user":"-","k":"construct-protocol-group","v":{"attributes":{":locale":"","authentication":"sspi","class":"msolap","dbname":"","server":"C:\\Temp\\SheffieldCityRegion_201516Final_Learner.cub"},"closed-protocols-count":"0","connection-limit":"16","group-id":"1","in-construction-count":"0","protocols-count":"0","this":"0x13b66108"}}

                      • 8. Re: SSAS Cubes and Tableau Desktop
                        Rachel Herrera

                        Lisa,

                         

                        I have been emailing with Tableau Support over this issue and here is what they told me to do. It worked for me so hopefully for you as well!

                         

                        Other individuals who were encountering the error 'Database error 0x80040154: Class not registered' when connecting to a Microsoft Analysis Services Cube were able to resolve the issue by manually downloading and installing the following drivers from the following link:

                                      

                        'Microsoft SQL Server 2016 Feature Pack'

                        https://urldefense.proofpoint.com/v2/url?u=https-3A__www.microsoft.com_en-2Dus_download_details.aspx-3Fid-3D52676&d=DwIFaQ&c=fa_WZs7nNMvOIDyLmzi2sMVHyyC4hN9WQl29lWJQ5Y4&r=-Vv7HuoQ8r1HNmqBei354B-NxUCdb6yb9sUXFOOY5kU&m=XYe67VDoZlBGhdaOZRW5KkZgwyC7BxONFpBMjkTVG5k&s=6g6zeL3jmf42gnO-udUX-I_tODm5AhoZgGatZcz65Do&e=

                                      

                        Once you click 'Download' select the following options:

                                      

                                       ENU\x64\SQL_AS_ADOMD.msi

                                       ENU\x64\SQL_AS_AMO.msi

                                       ENU\x64\SQL_AS_OLEDB.msi

                        • 9. Re: SSAS Cubes and Tableau Desktop
                          Rachel Herrera

                          Lisa,

                           

                          I have been emailing with Tableau Support over this issue and here is what they told me to do. It worked for me so hopefully for you as well!

                           

                          Other individuals who were encountering the error 'Database error 0x80040154: Class not registered' when connecting to a Microsoft Analysis Services Cube were able to resolve the issue by manually downloading and installing the following drivers from the following link:

                                        

                          'Microsoft SQL Server 2016 Feature Pack'

                          https://urldefense.proofpoint.com/v2/url?u=https-3A__www.microsoft.com_en-2Dus_download_details.aspx-3Fid-3D52676&d=DwIFaQ&c=fa_WZs7nNMvOIDyLmzi2sMVHyyC4hN9WQl29lWJQ5Y4&r=-Vv7HuoQ8r1HNmqBei354B-NxUCdb6yb9sUXFOOY5kU&m=XYe67VDoZlBGhdaOZRW5KkZgwyC7BxONFpBMjkTVG5k&s=6g6zeL3jmf42gnO-udUX-I_tODm5AhoZgGatZcz65Do&e=

                                        

                          Once you click 'Download' select the following options:

                                        

                                         ENU\x64\SQL_AS_ADOMD.msi

                                         ENU\x64\SQL_AS_AMO.msi

                                         ENU\x64\SQL_AS_OLEDB.msi

                          • 10. Re: SSAS Cubes and Tableau Desktop
                            Mariano Teixeira

                            Hi Lisa,

                             

                             

                            The log is reporting a different error from the one you see on your Tableau Desktop? On your first post, you mention Analysis Services database error 0x80004005. I don't see it on the logs, but a Error retrieving property 0x00000008.

                             

                            Anyways, try to install these two drivers manually once again (they are for Microsoft Analysis Services 2014 SP1, 32 bits - ):

                             

                            https://downloads.tableau.com/drivers/microsoft/2014/x86/SQL_AS_OLEDB.msi

                            https://downloads.tableau.com/drivers/microsoft/2014/x86/msxml6.msi

                             

                             

                            Best,

                            Mariano

                            • 11. Re: SSAS Cubes and Tableau Desktop
                              Lisa Clark

                              For future reference, I managed to sort this issue with assistance from the Tableau Support team.

                               

                              This issue with connecting to local cube files with Tableau Desktop 10.2 is currently under investigation (issue #611763). This issue does not occur with the 10.1.x versions of Tableau Desktop. Previous version of the installer can be found on our alternate downloads website:

                               

                              Alternate Downloads Site

                              https://www.tableau.com/support/esdalt

                               

                              There is no conflict in having multiple major versions of Tableau Desktop installed at the same time (eg 10.1.x and 10.2.x).

                               

                              I can confirm that, using Tableau 10.1.6, I can connect successfully to local cube files.

                              • 12. Re: SSAS Cubes and Tableau Desktop
                                Mariano Teixeira

                                Thank you, Lisa, for getting back with an update on this issue!

                                 

                                I'm sorry you've found an issue, but I'm glad we are working on it already to fix it as soon as possible!

                                 

                                Best,

                                Mariano