How To Add Gateway In Power Bi

by

To add a gateway in Power BI, follow these steps:

  1. Open Power BI Desktop and go to the “File” menu.
  2. Click on “Options and settings” and then select “Data source settings”.
  3. In the “Data source settings” dialog box, click on the “Gateway connection” tab.
  4. Click on the “Add gateway” button.
  5. Follow the on-screen instructions to download and install the gateway.
  6. Once the gateway is installed, go back to Power BI Desktop and select the “Manage gateways” option from the “File” menu.
  7. Click on the “Add gateway” button and provide the necessary details like the gateway name and the email address associated with the Azure Active Directory account.
  8. Click on the “Save” button to create the gateway.
  9. Now, you can configure data sources and data sets to use this gateway by selecting the gateway from the drop-down menu in the “Data source settings” dialog box.

Here is an example to illustrate the process:

Let’s say you have an on-premises SQL Server database that you want to connect to Power BI using a gateway.

  1. Install the gateway on a machine that has access to the SQL Server database.
  2. Open Power BI Desktop and go to the “File” menu.
  3. Click on “Options and settings” and then select “Data source settings”.
  4. In the “Data source settings” dialog box, click on the “Gateway connection” tab.
  5. Click on the “Add gateway” button and follow the on-screen instructions to download and install the gateway software.
  6. Once the gateway is installed, go back to Power BI Desktop and select the “Manage gateways” option from the “File” menu.
  7. Click on the “Add gateway” button and provide the necessary details like the gateway name and the email address associated with the Azure Active Directory account.
  8. Click on the “Save” button to create the gateway.
  9. Now, in the “Data source settings” dialog box, select the gateway you just created from the drop-down menu.
  10. Click on the “Add” button to add a data source.
  11. Select the SQL Server option and enter the necessary connection details like the server name, database name, and authentication method.
  12. You can test the connection to make sure it is working correctly.
  13. Click on the “Save” button to save the data source settings.

Now, whenever you create a report or a dataset using this data source, Power BI will use the gateway to securely connect to the on-premises SQL Server database.

Same cateogry post

Leave a comment