Forum Discussion
New server On-premise data gateway not visible
lshuba,
What data sources do you have in the existing dataset? You would need to add all the data sources of the dataset within configured gateway in Power BI Service, and the connection strings of the data sources should match these connection strings you use in Power BI Desktop.
However, if you combine online data source and on-premises data source in a single dataset, please check my replies in the following similar thread about how to use on-premises gateway to refresh dataset.
https://community.powerbi.com/t5/Integrations-with-Files-and/PowerBI-Enterprise-gateway-You-don-t-have-any-gateway-installed/td-p/400922
Regards,
Lydia
Hello
My datasources are 2 SQL server databases and 1 oracle database. I have 10 or so reports which are using the test gateway successfully. The new gateway has the exact same naming/connection string as the test gateway for the 3 sources. When i choose any of the reports and navigate on the dataset to schedule refresh, only the test gateway is visible as an option. As I will soon be leaving the company, there is a need to change to the service account/server gateway instead.
Thank you in advance.
lshuba,
Could you please post screenshot about data source settings in your PBIX file and the new gateway?
Regards,
Lydia