Azure Analysis Services Accessing On-Premise Data

bkundrat — Wed, 12 Jul 2017 11:46:17 GMT

I'm trying to POC the use of Azure AS using data from an on-premise SQL Server DB. To that end, I have an Azure AS instance created and have also installed the Azure AS Gateway on a VM on-prem. I then created a simple tabular project in Visual Studio with data from a table located in an on-premise database.

When I attempt to deploy the VS project to the Azure AS instance, the tabular metadata is deployed but I receive the following error when the data is being processed from the on-prem SQL Server DB:

Cannot process database. Reason: Failed to save modifications to the server. Error returned: 'An error occurred during On-Premise Gateway related activity. Additional error details: DM_GWPipeline_Gateway_DataSourceAccessError
Received error payload from gateway service with ID 1297307: Error creating OLE DB row set..
Error creating OLE DB row set.
Class not registered

When I look at the trace logs on the machine where I have the AS Gateway installed I see the following error as well:

DM.EnterpriseGateway Error: 0 : 2017-07-08T13:53:50.3245629Z DM.EnterpriseGateway   63ddf33a-3bdc-4ff8-aff1-76c8934f4ec6   b99d3f14-c0f4-4830-b799-188b5095da4a   MGON   b99d3f14-c0f4-4830-b799-188b5095da4a   6817BDD9 [DM.Pipeline.Common] Non-gateway exception encountered in activity scope: System.Runtime.InteropServices.COMException (0x80040154): Class not registered
   at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
   at Microsoft.PowerBI.DataMovement.Pipeline.OleDbBase.IDataInitializeExtensions.GetDataSource[T](IDataInitialize dataInitialize, CLSCTX clsCtx, String initializationString, Guid riid)
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ConnectionStrings.OleDbFullConnectionString.<>c__DisplayClass13_0.<InitializeDataSourceConnection>b__0()
   at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.ExecuteInActivity[T](PipelineActivityType pipelineActivityType, Func`1 action)

I was wondering if anyone has encountered this? It appears to be an issue with the GW connecting to the on-premise database but I'm sure why. I have the Azure Gateway service configure to log on as a domain admin account so it shouldn't be a rights issue.

Any thoughts would be greatly appreciated!

Thanks,

Bob K.

Re: Azure Analysis Services Accessing On-Premise Data

bkundrat — Wed, 12 Jul 2017 17:36:29 GMT

The problem has been fixed so I thought I'd post an update. It turns out I didn't have the correct driver (SQL Server Native Client 11.0) installed on the gateway machine. This fixed the issue.

topic Azure Analysis Services Accessing On-Premise Data in Developer

Azure Analysis Services Accessing On-Premise Data

Re: Azure Analysis Services Accessing On-Premise Data