Forum Discussion
bert631
9 years agoFrequent Visitor
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. ...
- 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
gmbhaskar
9 years agoNew Member
You need to use Analysis server username and password which means Analysis server running user name and password to set gateway when you are using Cubes or Models