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