Unable to connect XMLA power BI end point with Microsoft sql server management studio.

[shambhu]

Error -

The connection string is not valid. (Microsoft.AnalysisServices.AdomdClient)

----------

Connection details:

Service type : analysis services

server name - xmla end point path <Data source =...> /* 

authentication - windows

[Anonymous]

Hi @shambhu ,

Based on the description, try to verify that the XMLA endpoint setting is enabled for the tenant capacity.

Besides, try to create an environment variable on the windows.

Viewing the following documents to learn more information.

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

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

Semantic model connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft...

Best Regards,

Wisdom Wu

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

[bradsy]

https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools