Forum Discussion

lopezd's avatar
lopezd
Regular Visitor
10 years ago
Solved

GatewayPipelineErrorCode=DM_GWPipeline_UnknownError

Hi,   I´m traing to connect my AS database to Power BI pro but i´m getting this log error from my gateway log:   GatewayPipelineErrorCode=DM_GWPipeline_UnknownError InnerType=AdomdErrorResponseE...
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi lopezd,

    Please check the edition, version and patchlevel of your SSAS instance from the following registry. Make sure your SSAS instance meets requirement and you don't mix it with SQL Server Database engine.

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSAS11.InstanceName \Setup Keys: Edition ,PatchLevel , Version.



    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi lopezd,

Do you connect to multi-dimensional model on SQL Server 2012/2014 Standard edition? If that is the case, it is not supported currently.  As stated in this article, you need to have an Enterprise or Business Intelligence edition of SQL Server 2012/2014 Analysis Services, otherwise, you will get the above error message. Regarding to this limitation, you can also vote it in this idea: https://ideas.powerbi.com/forums/265200-power-bi/suggestions/11331360-connect-multidimensional-to-sql-server-standard-li

However, you are able connect to multi-dimensional models on SQL Server 2016 Standard edition from Power BI.

Thanks,
Lydia Zhang

lopezd's avatar
lopezd
Regular Visitor
10 years ago

Hi Lydia, thanks for your response. We are using the enterprise edition.

 

We can connect our Analysis services cube by importing the data but not in a live connection. I been looking for almost all the videos, we have been trying a lot of dirrerent things.

 

We get this message for PB Pro:

 

"There was a data source error. Please contact the gateway administrator"

 

And this message fot PB desktop:

 

"This data source does not support exploring with a live connection"

 

Do you know why we can´t connect?

 

Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi lopezd,

    Firstly, please verify that if you are connecting to SQL Server 2012 Analysis Services SP1 CU4 or later versions. You can execute "Select @@version" in SQL Server to check version and edition.

    Secondly, make sure that you don't have unprocessed SSAS databases.

    Thirdly, please use the latest version of Power BI Desktop.

    Thanks,
    Lydia Zhang

    • lopezd's avatar
      lopezd
      Regular Visitor
      10 years ago

      Hi Lydia,

       

      1.- We are connected to SQL Server 2012 Analysis Services SP1 CU4

      2.-All databases are updated

      3.-I unistall power bi destop and Download it again yesterday. How can i check if it´s the latest version?

       

      Thanks

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        Hi lopezd,

        In Power BI Desktop, you can go to File>Help>About to check its version. The latest version of Power BI Desktop is 2.37.4464.602, which can be downloaded is this link.


        Thanks,
        Lydia Zhang