Reply
Jul Frequent Visitor
Frequent Visitor
Posts: 2
Registered: ‎04-04-2017

powerbi gateway with no active directory account

hello,

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: george@contoso.com) is not set on the local Windows server, and not set to the local Sql Server

 

But how do I have to parameter it ?

thank you

Julien

Moderator
Posts: 2,229
Registered: ‎03-10-2016

Re: powerbi gateway with no active directory account

[ Edited ]

Hi @Jul,

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.

Thanks,
Lydia Zhang

Jul Frequent Visitor
Frequent Visitor
Posts: 2
Registered: ‎04-04-2017

Re: powerbi gateway with no active directory account

[ Edited ]

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...