Unable to connect to XMLA endpoint from SSMS

[Anonymous]

Hi,

I am trying to access a Power BI Workspace from SSMS as shown in the below video

https://www.youtube.com/watch?v=kXgm7984oTs

I am the Admin of the workspace and my manager is able to connect to the workspace using SSMS.

I have got the XMLA endpoint enabled.

But I am getting the below error.

TITLE: Connect to Server
------------------------------

Cannot connect to XXXXX

------------------------------
ADDITIONAL INFORMATION:

The remote server returned an error: (400) Bad Request.

Technical Details:
RootActivityId: b9cbcd5d-2219-4d86-ad11-5f483a0a7243
Date (UTC): 4/21/2021 2:12:18 PM (Microsoft.AnalysisServices.AdomdClient)

------------------------------

The remote server returned an error: (400) Bad Request. (System)

------------------------------
BUTTONS:

OK
------------------------------

Any suggestions are helpful?

[Anonymous]

HI @Anonymous,

'400' error code normally means sent requests not suitable for the remote servers.

400 Bad Request - HTTP | MDN (mozilla.org)

Can you please share some detailed information about this issue? You can ask the support to use the activity id to get the detailed error message.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Anonymous]

Hi,

I have this requirement to refresh individual table in Power BI report rather than refreshing the whole report.

In the below video it shows how to refresh individual table using XMLA endpoint.

https://www.youtube.com/watch?v=kXgm7984oTs

In the video he clearly shows how to connect to workspace using SSMS.

Interesting thing is my manager is able to connect to the worksace using SSMS and I am getting the below error.

TITLE: Connect to Server
------------------------------

Cannot connect to XXXXX

------------------------------
ADDITIONAL INFORMATION:

The remote server returned an error: (400) Bad Request.

Technical Details:
RootActivityId: b9cbcd5d-2219-4d86-ad11-5f483a0a7243
Date (UTC): 4/21/2021 2:12:18 PM (Microsoft.AnalysisServices.AdomdClient)

------------------------------

The remote server returned an error: (400) Bad Request. (System)

------------------------------
BUTTONS:

OK
------------------------------

If anybody could let me know if there is any other way to individually refresh a single table rather than the whole report that would be really helpful.

Many Thanks.

[Anonymous]

HI @Anonymous,

Any difference between your test account and your manager account? Have you tested on the same environment/device?

BTW, since this is related to SSMS, did you have correspond account/role settings on the 'SQL Server' side that map with the power bi account?

Regards,

Xiaoxin Sheng