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.
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.
Thank you for you assistance. After following your steps, it still wouldn't allow me to connect to the data gateway. I realized it was because one of the tables in the desktop version was one I created and not from the same data source. Once I deleted that table from the published version, problem solved. Thank you again.