Cannot connect to Analysis Services via Excel

• Bhagat

  SSC-Addicted

  Points: 405

  More actions

  September 30, 2024 at 10:19 am

  #4463728

  For myself this seems to work and for other users they receive this error:

  Errors in the OLE DB provide. We could not establish a connection to the "Server/Instance" Analysis Services server. Please verify that you can connect to this server, and that the SQL Browser redirector service is enabled.

  This a 2016 SSAS Tabluar Model deployed to a production server.

  I can connect to the database engine and analysis services via SSMS on my machine. My colleague can also do this and we both can write SQL/MDX queries.

  I also can connect via Excel (365) from my machine when I get data from Database > Analysis Service within Excel. My colleague receives the above error.

  Any ideas on what to check?

  Thank you.

• Site Owners

  SSC Guru

  Points: 80332

  More actions

  October 1, 2024 at 11:10 am

  #4464137

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• December 17, 2024 at 7:25 pm

  This was removed by the editor as SPAM