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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors