Forum Discussion

gooranga1's avatar
gooranga1
Icon for Power Participant rankPower Participant
10 years ago

Enterprise Gateway mashup error

We have just switched to the Enterprise Gateway. We have set up our datasets fine and when we test them they all come back with good to go.   However when we try to refresh either by schedule or ma...
Need Help
Tsanka's avatar
Tsanka
Icon for Kudo Collector rankKudo Collector
10 years ago

I am experiencing the same error. My case is the following:

- dataset from a multidimensional SSAS in a domain different from the one I use for Power BI;

- the enterprise gateway is setup with a user name/password from the domain of the SSAS 

- the EGW is online, the connection is checked and the dataset is set to be refreshed from it;

- the refresh produces the same error as yours.

 

I wonder if this a supported scenario (using the EGW to access multidimenasional SSAS from another domain)

gooranga1's avatar
gooranga1
Icon for Power Participant rankPower Participant
10 years ago

Hi, We had to get our network guys to set up a spoof, so our power bi logins trick the data source server we are from that domain. A very big fudge based on this post my colleague found.

 

About 2/3 the way down this blog post entitled "Setting up a Demo of the Power BI Analysis Services Connector"

 

http://www.artisconsulting.com/blogs/greggalloway/