Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Safuvanc
New Member

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.

 

Safuvanc_0-1699942271763.png

 

 

Thanks

3 REPLIES 3
Anonymous
Not applicable

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.

Brunner_BI
Super User
Super User

What are you doing in Power Query exactly?

------------------------------------
Brunner BI focusing on Microsoft Power BI development and consulting
Developers of external tool "Measure Killer"
My blog

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.

Safuvanc_0-1699953524459.png

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.