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

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

      • lopezd's avatar
        lopezd
        Regular Visitor
        10 years ago

        Hi Lydia,

         

        Thanks for the response we have the new version now. We can not get live connection jet. SQL Server Analysis Services Tabular model databases as well as multidimensional models? or should be one or the other?

         

        Thanks