Forum Discussion

Safuvanc's avatar
Safuvanc
New Member
2 years ago

XMLA endpoint issue

 

Hi,
I have tried to connect XMLA endpoint with external user, but while publishing gettting this error.
Please let me know for any available solution for this.

 

 

 

Thanks

Data Protection
Need Help

3 Replies

    • Safuvanc's avatar
      Safuvanc
      New Member
      2 years ago

      Hi,
      I have connected the xmla endpoint through sql server analysis database in powerbi desktop, didnt made any changes to power query. But im unable to publish it in service which is showing the error.

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Safuvanc ,

    There could be several reasons why you’re encountering this error. Here are some possible solutions:

    Check your network connectivity: Ensure that you have a stable internet connection and that the external user is able to connect to the XMLA endpoint. If the external user is unable to connect, it could be due to a firewall or network issue.

    Check your credentials: Ensure that you have the correct credentials to connect to the XMLA endpoint. If you’re using a service principal, ensure that the application identity information is specified in the connection string as User ID=<app:appid@tenantid> Password=<application secret>.

    Check the XMLA endpoint settings: Ensure that the XMLA endpoint is enabled on both Power BI Premium, Premium Per User, and Power BI Embedded capacities. If you’re encountering an error while trying to set the XMLA Endpoint to Read/Write, try limiting the memory consumption of other services on the capacity or upgrading the capacity to a larger SKU.

    Check your environment variables: If you’re using SSMS 19 and encountering an error while logging into the XMLA endpoint, create an environment variable named with a value of MS_AS_EnforceAdalUsage 1.

    Troubleshoot XMLA endpoint connectivity in Power BI - Power BI | Microsoft Learn

    Solved: Re: Is it me or is XMLA Endpoint incompatible with... - Microsoft Fabric Community

     

    If I have misunderstood your meaning, 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.