Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Unable to connect to XMLA endpoint from SSMS

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 co...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    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