Forum Discussion

bergerlu's avatar
bergerlu
Helper I
5 years ago

PBI Embedded Capacity SSMS error

Hello,

 

I'm connected to my PBI Embedded Capacity via SSMS. When I right click on the analysis service and go to properties -> general, I get this error. I am the owner and administrator of the capacity. What gives ?

 

 

===================================

The connected user is not an Analysis Services server administrator. Only an administrator can view/edit server properties. (Microsoft.AnalysisServices.SsmsManagementDialogs)

------------------------------
Program Location:

at Microsoft.AnalysisServices.ManagementDialogs.CUtils.GetServerAsAdmin(IExDataContainer context)
at Microsoft.AnalysisServices.ManagementDialogs.ServerPropertiesGeneralPanel.InitProp()
at Microsoft.AnalysisServices.ManagementDialogs.ServerPropertiesGeneralPanel.OnInitialization()
at Microsoft.SqlServer.Management.SqlMgmt.ExPanelFormWrapper.OnInitialization()
at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.SetView(Int32 index, TreeNode node)
at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.OnBeforeSelection(Object sender, TreeViewCancelEventArgs e)

 

 

 

 

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi bergerlu ,

    According to the error message, it seems that the error caused by you are not the administrator of Analysis Services... How did you connect to Analysis Services? And did you enable XMLA read-write and Export data feature?

    Connect with SSMS

    Best Regards
    Community Support Team _ Rena Ruan
    If this post helps, then please consider Accept it as the solution to help the other members find it more.

    • bergerlu's avatar
      bergerlu
      Helper I

      Hi, Anonymous 

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi bergerlu ,

        Could you please check whether follow the process in the following link when you connect to Analysis Services? As checked the screenshot in previous post, it display the server name is "Mashup"....

        Connect with SSMS

        Best Regards
        Community Support Team _ Rena Ruan
        If this post helps, then please consider Accept it as the solution to help the other members find it more.