04-04-2017 06:01 AM
I've installed a SQL server 2016 on a windows server 2012 R2.
I've installed SSIS and built a SSIS solution, with a tabular cube.
this server is not in a domain: the customer has no Active Directory
the got office 365 account and i would like tu use the powerbi gateway to sent their data, so that they can use it on thier office 365 account.
Once the gateway installed, I can't manage to set up a new datasource on my gateway. The error message tells me the autentication information are wrong.
Seems logical since the 365 user (ex: firstname.lastname@example.org) is not set on the local Windows server, and not set to the local Sql Server
But how do I have to parameter it ?
04-04-2017 07:36 PM - edited 04-04-2017 07:37 PM
What data source do you add under the gateway? And what is the full error message do you get?
If you add SSAS data source under gateway, the Windows account you enter must have Server Administrator permissions for the instance you are connecting to. Moreover, you would need to add the machine that installs SQL Server to a domain. As per this article, the email address you sign in Power BI should match a defined UPN within the local Active Directory Domain. The UPN is a property of an Active Directory account. That Windows account then needs to be present in an Analysis Services role. If a match cannot be found, in Active Directory, the login will not be successful.
04-19-2017 05:07 AM - edited 04-19-2017 05:09 AM
Thank you for your answer. Since I wrote this, the customer's server is down and I'm still waiting for technical intervention to repair it...