Forum Discussion

jbocachica's avatar
jbocachica
Resolver II
11 years ago

Analysis Services Connector limitations

Hi all, I'm trying to identify if there is some limitations with the Analysis Services Connector?, something like size of data, size of query, number of dimensions, things like that.

 

Regards

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    11 years ago

    I think about size of data, size of query, number of dimensions - does not affect , it will treat this as general.

    Addition details - 

    Currently, other on-premises sources are not refreshable yet within the Public Preview, Got this from Adam's Blog (http://blogs.technet.com/b/powerbisupport/archive/2015/02/17/a-look-at-the-analysis-services-connector.aspx)

    Updated on Enable connectivity to on-prem (or IaaS) SSAS Cubes / multidimensional!, here is idea supporting this with high votes https://support.powerbi.com/forums/265200-power-bi/suggestions/6606693-sql-server-analysis-services-cubes

     

    Two important points to note down from power bi support website (https://support.powerbi.com/knowledgebase/articles/471577-configure-a-power-bi-analysis-services-connector)

    • Only SQL Server Analysis Services Tabular models are supported for Power BI Preview
    • The connector has to continue running and the computer where it is installed has to remain on.

    With Prerequisites (https://support.powerbi.com/knowledgebase/articles/471577-configure-a-power-bi-analysis-services-connector)

    • .NET Framework 4.5.1 or later must be installed on the computer.
    • Installing the Power BI Analysis Services Connector and the Data Management Gateway on the same computer is not supported. If you already have the Data Management Gateway installed, uninstall it before installing the Power BI Analysis Services Connector, or install the Connector on different computer.
    • The Analysis Services server is domain joined.
    • The Analysis Services connector & Analysis Services server are installed on computers in the same domain.
    • If you use an .onmicrosoft.com email address, you'll need to sync your Active Directory to Azure Active Directory using Azure Active Directory Sync (DirSync). To learn more. See Power BI Analysis Services Connector in-depth.

    You can read additional FAQ here related to this topic  

    http://blogs.msdn.com/b/powerbi/archive/2015/03/11/power-bi-analysis-services-connector-deep-dive.aspx

     

    Also take one look here on ideas associated with SSAS (https://support.powerbi.com/forums/265200-power-bi?query=SSAS)

     

    All Power BI support links for SSAS realted topics are here 

    Hope this helps 

     

    Vishal Pawar

    BI Solution Architect 

    • GuyInACube's avatar
      GuyInACube
      Administrator
      11 years ago

      Internet latency is also something to consider.  You can use Fiddler to identify where the requests are going do, and then evaluate what kind of altency you have with regards to performance.  You may not be able to do a whole lot about it, but it may give you some idea if things seem sluggish as it can contribute to that.

      • luisrh's avatar
        luisrh
        Responsive Resident
        11 years ago

        A gap in the functionality of the SSAS connector is also that it cannot connect to an HTTP pump end point.  This makes is hard to support ISV's who host customer tabular and dimensional data sources on their cloud for u;sers.   The way it works now and the way it seems to have been envisioned is to serve IT departments who synch to AD Azure and not for an ISV who supports hundreds of different customers and also use a different type of authentication.   Also,  it assumes that the security on the cubes are role based, rather than dynamic security based on DAX or MDX filtering.  Microsoft needs to allow connections to HTTP SSAS Pump endpoints as Excel or other tools always have -  With this approach ISV's or anyone not able to synch with Azure AD to manage the connection as well as mapping to internal identity through an httphandler proxy.    Allowing this, rather than thinking that EffectiveUserName will work in lieu of Azure AD synching.   We have thousands of users that use Excel to get to tabular models this way now.   We would love to able to offer the same capabilities thru Power BI.   I have discussed this with some MSFT folks already.  I really hope this is being considered as it's a main showstopper for us.   A large problem is also that some of these are European customers and they do not want to move their data to 'yet another cloud provider'.    MSFT please consider resolving this issue soon.   It will open up the capabilities for your ISV's and also get more Power BI subscribers.

        thank you,

        Luis

  • andre's avatar
    andre
    Memorable Member
    11 years ago

    There are two things that I would consider:

     

    1. I would install the PBI AS Connector on the same box as AS to minimize latency
    2. EffectiveUserName is not being passed right now so, "effectively", there is no security. My guess is that it's safe to assume that this will work by GA time, but I would be careful with exposing sensetive data through Power BI preview site right now.

     

     

    • GuyInACube's avatar
      GuyInACube
      Administrator
      11 years ago

      EffectiveUserName is passed with the requests.  I just verified off of the AS Connector that is available on the Microsoft Download Page.  

       

      I've never seen it not pass EffectiveUserName.  I'm not sure what you were referring to.