Power Bi Gateway - Connection to SSAS Cube On-Premise

[gennarodimeo]

Hi Guys, I'm having a problem connecting to a SSAS Cube through the Enterprise Gateway. This is my configuration: -Windows Server 2012 R2 -SqlServer Standard 2016 (evaluation) with latest CU -No Active Directory on-premise -Power BI Enterprise Gateway installed on the same machine This is what happens: -I can connect to the SSAS cube from Excel remotely (through a vpn) -I can connect to the gateway from Power BI service -I can create a Data Source pointing to the on-premise SSAS cube (I've mapped the online user with a local user whit accessing rights to te cube) -I can successfully perform a connection test -The data source is correctly listed in "Sql Server Analysis Srvices" But when I try to "get data" connecting to the data source, I get a very generic error in this form: Servers>MultidimensionalTestBi_02 Something went wrong. Technical details: Activity ID: ... Request ID: ... Date: ... Error test: System Error Cluster URI: ... Sql Server Profiler shows exactly the same error message, not very helpful I'd say. What am I doing wrong_ Thanks.

[gennarodimeo]

Hi Christian, I'm using PowerBi Service (online). I 've tried PowerBi Desktop as well but it doesn't work either.

[christian_s_osb]

Are you connecting via Desktop or online? Something that may work in the short term is to pull the data into excel and build a tabular power pivot model and publishing that up to PB online with a refresh scheduled.