Forum Discussion
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...
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:
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)
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:
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.
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