cancel
Showing results for 
Search instead for 
Did you mean: 
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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Kudoed Authors