Forum Discussion

BenMackin's avatar
BenMackin
Icon for Helper I rankHelper I
3 years ago

XMLA Endpoint and Excel

Hello all.   Trying to work through a strange XMLA Endpoint issue. Everything works fine with Power BI Desktop, and even Excel Power Query when interactive with the XMLA Endpoint. However, when I t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi BenMackin ,

It seems like you are experiencing some issues with connecting to an XMLA endpoint using Excel Power Pivot. Here are some potential solutions to the issues you are facing:

  1. To resolve the issue with the authentication token, try specifying empty values for the 'User Name' and 'Password' fields, and then retry. You should then be prompted to enter your credentials.

  2. To remove the SSPI from the Integrated Security subsection, click on Advanced in the 'From Analysis Services or PowerPivot' pop-up, and then remove SSPI from the Integrated Security subsection under Security. Make sure to click on Test Connection after removing SSPI to authenticate with your Microsoft account.

  3. To resolve the issue with the query interface not working against an XMLA endpoint, try hand writing a query (DAX or MDX) instead of using the 'Design' button. This should allow you to load the data into your Power Pivot.

  4. To resolve the issue with the Power Pivot connection not saving the fact that you removed the SSIP from the Integrated Security, try saving the connection string as a separate file and then importing it into your Power Pivot. This should ensure that the connection string is saved correctly.

I

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details.

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.