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

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

  • jennyy's avatar
    jennyy
    Frequent Visitor
    8 years ago

    I am also getting same error? Any update?  Thanks