cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Remek1
Frequent Visitor

XMLA Endpoint connection Bad Request(400)

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

Remek1_0-1656359492499.png

 

Its the same with SSMS:

Remek1_1-1656359636600.png


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




1 ACCEPTED SOLUTION
Hariharan_R
Solution Sage
Solution Sage

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


View solution in original post

2 REPLIES 2
Hariharan_R
Solution Sage
Solution Sage

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


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...

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors