Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
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.
What are you doing in Power Query exactly?
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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.