Forum Discussion

bert631's avatar
bert631
Frequent Visitor
9 years ago
Solved

On-Premise Data Gateway: Data source access error

I'm trying to link the Power BI app to my on premise SSAS cube by using the Data Gateway, but the dataset returns an error: Data source access error. Please contact the gateway administrator   1. ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi bert631,

    It requires an Enterprise or Business Intelligence edition of SQL Server Analysis Services when you connect live to SSAS 2012 from Power BI.

    In your scenario, you would need to upgrade SQL Server 2012 Standard to SQL Server 2016 Standard, alternatively, you can perform a edition upgrade to change the edition of SQL Server 2012 to Enterprise or Business Intelligence edition.


    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi bert631,

It requires an Enterprise or Business Intelligence edition of SQL Server Analysis Services when you connect live to SSAS 2012 from Power BI.

In your scenario, you would need to upgrade SQL Server 2012 Standard to SQL Server 2016 Standard, alternatively, you can perform a edition upgrade to change the edition of SQL Server 2012 to Enterprise or Business Intelligence edition.


Thanks,
Lydia Zhang

  • zgehasz's avatar
    zgehasz
    New Member
    9 years ago

    Hi Lydia,

     

       Quick question.  You mention needing to upgrade to SQL 2016 standard as an option to get around this problem with the SSAS gateway.  Or I can upgrade to 2012 enterprise or BI.  What if I upgrade to SQL 2014 standard, will that allow the SSAS gateway connection?  Or is 2014 like 2012 needing enterprise or BI?

     

    Thanks,

     

    Zach

  • rfratto's avatar
    rfratto
    Advocate I
    9 years ago

    Lydia-

    Should this work with SQL Server Developer Edition?  I'm in development using the gateway in what appears to be the same problem space: the settings for the dataset indicate that the Gateway is online and the data sources are online but I am getting a 'Data Source Access Error' when running the report.

    -Ray

     

    • mdaamirkhan's avatar
      mdaamirkhan
      Post Prodigy
      8 years ago

      I am also getting same error 

      • jennyy's avatar
        jennyy
        Frequent Visitor
        8 years ago

        I am getting same error. Any update? i am using SQL 2016 Standard edition. Thanks