Problem with on premise gateway connected to two different servers

[am_0106]

Hi,

I have a on prem gateway which is connected to two different servers one is prod and the another one is the test. I created one report using test server and published it to the Power BI Services and connected the data source to the service account which has all the permissions in the SSAS database to read the data. Now, I created another report connected to the prod server and publish that report to the POwer BI services which created a new datasource and connected with another service account which has admin permissions in  SSAS database, but the problem here is that our reports do not display and data in Power BI services. Is it a gateway issue or is it something related with Datasource name.

I really want someone who can help me with this as it is very critical to our Prod release. 

[v-xicai]

Hi  @am_0106  ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai]

Hi @am_0106 ,

If it is a gateway issue or it is something related with Datasource name, there must be some error messages displaying in manage gateway page.

To show data, besides add data source under Manage gateway, you also need to map user name for the SSAS data source, see more details: https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-ssas#map-user-names-for-....

Best Regards,

Amy

Community Support Team _ Amy

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

[Seth_C_Bauer]

@am_0106 This sounds like two different potential issues... The server you have the gateway on needs to have access to both environments. This seems a bit jinky depending on what sort of environment you have because dev and prod is typically sourced from two different domains which would make a single gateway approach pretty hard to do since it would have to cross domains. In any case, if they are in the same domain, and the datasources you created in the Service test correctly then you shouldn't have an issue. If the reports aren't refreshing or connecting to the gateway datasources then you need to ensure that the report connections match the same names you used to create the datasource in the gateway.

You should see data in the report no matter what in the report you publish...