Forum Discussion
Connect to data gateway
davishert I assume you installed the On-Premises Data Gateway. Once you have that installed, you need to go to the Power BI Service and under "Settings" (the gear) click on Manage Gateways. This will give you a list of the OPD gateways you have installed and have access to. You can use this example of creating a data source to a SQL Server as an example walkthrough. But essentially you need to create a data source with the connection strings that match exactly to the connection strings in your Desktop file. Then, publish the PBIX file and the gateway will appear as one that you can use under your dataset to refresh.
If you can figure that out and let me know, I would be grateful. What I've learned so far is that in PowerBI Service you cannot combine datasets. A published data set (from PowerBI desktop) with different sources won't connect to a data gateway in PowerBI Service, but I hope I'm wrong.
The order of operations is important (from my experiance). You want to make sure the data source/s exist in the OPD Gateway prior to publishing the Desktop file. That way, it automatically recognizes the data source and will allow you to use it.
To the multiple data source question. You can use multiple data sources in the Desktop, you just need to make sure that all the data sources are supported and created in the OPD gateway. Otherwise it will either not work, or default to the personal gateway.