cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BAlexandrov Occasional Visitor
Occasional Visitor

On-premise gateway to OLAP w/o Active Directory

Hi all,

We're evaluating PowerBI for reporting tool in a small organization. We use Office365 and bundled free PowerBI and SQL Server Standard on a VPC in a cloud. On the same machine is installed On-premise gateway. The machine is not part of a domain. There are also installed SQL Server Analysis services tabular model.

Connection to OLAP works using local user account(on the machine) with Excel easily and with PBI Desktop if is started with that account with runas user /netonly and there are no problems with this.

 

The problem is connecting app.powerbi.com to on-premise Analysis services.

 

Connection from app.powerbi.com works for SQL Server, using basic authentication, but does not work for Analysis services. Connection is made with that same local user account, who have permissions on OLAP and works with Excel/PBI Desktop. Test connections works but uploaded report cannot refresh and gives error refreshing. 

 

The error at the gateway logs is "The name provided is not a properly formed account name. ". Full text at the end.

 

Runing the gateway with administrative account does not help.

Specifying the user name as machinename\user does not help - Test connection works if the password is right so there is connection!

Experimenting with ADUserNameLookupProperty, ADUserNameReplacementProperty gives error that there is no domain available.

 

Full error:

GatewayPipelineErrorCode=DM_GWPipeline_Gateway_DataSourceAccessError
GatewayVersion=
ErrorCode=-1056899072 --->
[1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: AdomdErrorResponseException:<pi>Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: The following system error occurred:  The name provided is not a properly formed account name. 
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.OpenConnectionAsync()</pi>

GatewayPipelineErrorCode=DM_GWPipeline_UnknownError
GatewayVersion=
InnerType=AdomdErrorResponseException
InnerMessage=<pi>The following system error occurred:  The name provided is not a properly formed account name. </pi>
InnerToString=<pi>Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: The following system error occurred:  The name provided is not a properly formed account name. 
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.OpenConnectionAsync()</pi>
InnerCallStack=   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.OpenConnectionAsync()
  ([1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException.StackTraceSmiley Happy
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.OpenConnectionAsync()
   --- End of inner exception stack trace ---
1 REPLY 1
Community Support Team
Community Support Team

Re: On-premise gateway to OLAP w/o Active Directory

Hi @BAlexandrov 


@BAlexandrov wrote:

On the same machine is installed On-premise gateway. The machine is not part of a domain. There are also installed SQL Server Analysis services tabular model.


There may be some configuration missing, please learn how to refresh SSAS data in power bi from this video.

From this official document, when using Windows account for refresh, it must have Server Administrator permissions for the instance you are connecting to.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 59 members 1,191 guests
Please welcome our newest community members: