Cannot connect to Analysis Services via Excel

  • 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.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply