In Excel, go to the Data tab of the ribbon, click Get Data
and select From Database → From Analysis Services. Then, enter the
credentials.To find your MDX API credentials, go to the Integrations page, click
API credentials, and choose the MDX API tab.