PowerBI Service and Enterprise Gateway not working with 2 on prem data sources which are different.

[msgeorgie]

Anyone experience a problem being able to setup an enterprise gateway on a premium workspace when you pbix file contains a mixture of on prem datasources (Teradata and MSSQL in my case)?  I am able to see the enterprise gateway configuration option when I only have my Terradata datasource in the pbix file or my MSSQL datasource in the pbix file. 

Once i have both in the pbix file and I publish it to the Premium Workspace and attempt to setup up the gateway it isnt available for me.  

When i have both Teradata and MSSQL datasources in my PBIX file.

[v-xuding-msft]

Hi @msgeorgie ,

After testing, my sample also works fine. You could reference the way that rgnanaprkaash suggested. And if the version of gateway is not 3000.31.3, please install the latest one.

If it still can't work, you could try to create a support ticket to get the dedicated support.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @msgeorgie 

I tested this combo and i don't have any issues.

Please make sure your account is added as user to the data source connection created on the on-premise gateway.  If this is already done, then it could be a transient issue.  Try re-publishing the report to the service and see if that works.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.