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

Need Help

3 Replies

    • 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