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