Forum Discussion

johnchill's avatar
johnchill
Helper I
10 years ago

Error when connecting to SQL server analysis services database

I am receiving an error when attempting to load data from Analysis Services into PowerBI. The error message is: Load Name of datasource Datasource.Error: AnalysisServices: The Auto Exist operat...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

Hmm, what version of SSAS are you running? It is possible that it is Analysis Services that is generating the error, there are memory limitation settings and such for SSAS. For example, this is for 2005 but you could check SSAS settings like BufferMemoryLimit:

 

https://technet.microsoft.com/en-us/library/cc966526.aspx

 

  • johnchill's avatar
    johnchill
    Helper I
    10 years ago

    Thanks, I will look at that.

    I don't get that error when using Excel with the same data from Analysis Services though.

     

    John

    • rojosevi's avatar
      rojosevi
      New Member
      10 years ago

      Hi,

       

      I'm getting the same issue when I add in an extra dimension attribute. I'm guessing its complaining about the volume of data being generated but Excel happily deals with the level of data being requested.

       

      Could it be something to do with the SSAS connector that Power BI uses?

       

      Is there any solutions?

       

      Thanks