XMLA Endpoint connection Bad Request(400)

[Remek1]

Hi,
I Need to connect to Dataset using XMLA but I'm receiving below error:

Its the same with SSMS:

Just to add: Yes we are using Premium, it is working for others so thats just my issue, I Dont think its "conection string" issue beuase I'm taking it from Power BI (copy), my credentials are fine too

Any ideas what is going on?

Thanks

[Hariharan_R · Accepted solution]

Hi @Remek1 

Please make sure you satisfy all the requirements to connect through XMLA. If this is working for others and not you then, check below points.

1. Ensure connection string is correct

2. Ensure credentials are correct

3. Analyze in Excel in Admin portal is enabled and if there are any security groups then please be a part of that security group.

https://powerbi.microsoft.com/en-us/blog/power-bi-open-platform-connectivity-with-xmla-endpoints-pub...

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin

[Remek1]

Hi,

It turned out to be that I'm one of the groups in the entire organization which has this kind of access blocked,

It's a blow for me due to other projects, but at least I now know what is going on...