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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
CSun
Frequent Visitor

Gateway and domains setup

I am working on Azure AS Tabular Model which is in domain X. My datasource is on-prem in domain X.  I am working from domain Y and the gateway is setup in domain y. 

 

I couldn't find much documentation around cross-domain setup for the gateway. So here are my questions:

1. Is this right\reccomended setup? If not what is the reccommended setup?

2. Are there any documentations around this?

 

With my setup, when i deploy my tabular model to the Azure AS  i encounter the below errors:

 

I get this error when I can deploy my metadata but processing fails:

[DM.GatewayCore] ServiceEndpoint Connection status: Connecting, LastError: 'System.ServiceModel.CommunicationException: The connection was inactive for more than the allowed 240000 milliseconds and is closed by container '2cfbf48f3a584793b672affba704b4dd_G53'. ---> Microsoft.ServiceBus.Messaging.Amqp.AmqpException: The connection was inactive for more than the allowed 240000 milliseconds and is closed by container '2cfbf48f3a584793b672affba704b4dd_G53'.
   --- End of inner exception stack trace ---'

 

I get this error when i can deploy, processing starts and retrieves about 2.1 million rows, and then stays like that for some time and fails:

[DM.Pipeline.Diagnostics] Exception object created [IsBenign=True]: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.CancellationException: Task is timeouted with System.Threading.Tasks.TaskCanceledException: A task was canceled.
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.PowerBI.DataMovement.Pipeline.Common.TDFHelpers.<>c__DisplayClass7_0`1.<<GetNextResponse>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.PowerBI.DataMovement.Pipeline.Common.TDFHelpers.<>c__DisplayClass10_0.<<ExecuteBlockOperation>b__0>d.MoveNext(); ErrorShortName: CancellationException/TaskCanceledException[HResult=-2146233029]
DM.EnterpriseGateway Information

 

Any help would be appreciated.

1 ACCEPTED SOLUTION

Hi @CSun,

 

Of course. You can install the on-premise data gateway on the same machine which has the SQL server runs, as long as the server host data gateway can access the SSAS.  You can follow this article to install data gateway.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-qiuyu-msft
Community Support
Community Support

Hi @CSun,

 

If the Analysis Services server is in a different domain than the data gateway and there is not a two-way trust established. Then you will not be able to use the data gateway to connect this SSAS server. In your scenario, you will need to work with your domain administrators to verify the trust relationship between domains. See: On-Premises Data Gateway FAQ.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Can I install the gateway in the same server where my backend sql server (domain x) is residing? 

Hi @CSun,

 

Of course. You can install the on-premise data gateway on the same machine which has the SQL server runs, as long as the server host data gateway can access the SSAS.  You can follow this article to install data gateway.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors