Forum Discussion
On-Premise Data Gateway: Data source access error
- Anonymous9 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
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
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
- mdaamirkhan8 years agoPost Prodigy
I am also getting same error