Connect with Excel#

An atoti session comes with its one dashboarding app but it can also be queried from other clients such as Excel.

With Excel, the connection is done through the session xmla endpoint. This endpoint is accessible by adding /xmla to the end of the session URL (e.g. f"http://localhost:{session.port}/xmla" for a local session).

Create a new connection to an Analysis Services. Use this URL for the server field and choose to connect with “User Name and Password”:

Connect with excel