Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
cryan
Frequent Visitor

Enterprise Gateway with Analysis Services Tabular

Anyone have success connecting to a live tabular model with Enteprise Gateway? What I think I've seen in the documentation is that the Power BI account comes in with a company email (user@biz.com) which matches against an on-prem UPN (user@biz.com), which then uses that effectiveusername (domainname\user to query Analysis Services. Authentication and data is then returned through the gateway based on the SSAS roles that are set up for that user. 

 

Within SQL Profiler, I can see the Power BI Desktop connection making it's way to SSAS and I also see the checks taking place within SSAS, both when I make changes to the Gateway and also when I publish the model from the desktop app. But when I try to view the dataset or report within powerbi.com all I see is a very generic "Data Source Access Error. Please contact the gateway administrator."

 

Nothing appears within Profiler when I'm refreshing the dataset on powerbi.com, just that error in the browser. Within the gateway logs I'm getting this exception... It's lengthy, but you can see the connection string provided and then the exception thrown.

 

SQL Data Sources work great with Enterprise Gateway, it just seems to be SSAS Tabular for me. Thanks!


DM.EnterpriseGateway Information: 0 : 2016-02-02T00:41:41.0597930Z DM.EnterpriseGateway e0853580-774a-44a9-8cdc-2106ed237258 b0142ef9-0544-cb47-8d8d-c1ff77fa3f59 MGGC 3b5c0121-c574-24f0-d877-7265f7170f07 60823F31 [DM.GatewayCore] Processing database connection establishment to [MSOLAP.5: <pi>provider=MSOLAP.5;data source=mydb\tabular;initial catalog=wwrev;cube=Model;sspropinitappname=PowerBI;effectiveusername=cryan@biz.com;connect timeout=60</pi>]
DM.EnterpriseGateway Information: 0 : 2016-02-02T00:41:41.0597930Z DM.EnterpriseGateway e0853580-774a-44a9-8cdc-2106ed237258 b0142ef9-0544-cb47-8d8d-c1ff77fa3f59 MGGC 3b5c0121-c574-24f0-d877-7265f7170f07 B6980A24 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedSuccessfullyEvent (duration=1)
DM.EnterpriseGateway Error: 0 : 2016-02-02T00:41:41.0597930Z DM.EnterpriseGateway ad3282c4-73bd-41f7-9312-4f9c5c7c2f35 b0142ef9-0544-cb47-8d8d-c1ff77fa3f59 MGGS 3b5c0121-c574-24f0-d877-7265f7170f07 1289EE59 [DM.Pipeline.Diagnostics] Exception object created: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.DataAccessException: An exception encountered while accessing the target data source(wrapped: MissingMethodException/Method not found: 'System.Data.DataSet Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(System.String, System.String, Microsoft.AnalysisServices.AdomdClient.AdomdRestrictionCollection, Boolean, Microsoft.AnalysisServices.AdomdClient.AdomdPropertyCollection)'.)

 

 

1 REPLY 1
cryan
Frequent Visitor

I think my earlier version of the Enterprise Gateway was the issue. After uninstalling the preview version from December and then reinstalling the latest, all is working great.

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors