How To Add Data Source To Gateway Power Bi

How to add data source to Gateway Power BI

To add a data source to Gateway Power BI, follow these steps:

1. Download and install the Power BI Gateway software from the official Microsoft website.
2. Launch the Power BI Gateway application on your computer.
3. Sign in with your Power BI account credentials.
4. On the Power BI Gateway dashboard, click on the “Add Data Source” button.
5. Select the type of data source you want to add. Options include SQL Server, Oracle Database, SharePoint List, etc.
6. Provide the required details for the selected data source. This may include server address, database name, username, password, etc.
7. Click on the “Test Connection” button to ensure that the connection details are correct and the data source can be accessed.
8. If the connection test is successful, click on the “Add” button to add the data source to Gateway Power BI.
9. Repeat the above steps for any additional data sources you want to add.

Once the data sources are added, you can use them in Power BI to create reports, dashboards, and visualizations.

For example, let’s say you want to add a SQL Server database as a data source:

1. Download and install the Power BI Gateway software.
2. Launch the Power BI Gateway application.
3. Sign in with your Power BI account credentials.
4. Click on the “Add Data Source” button.
5. Select “SQL Server” as the data source type.
6. Provide the server address, database name, username, and password.
7. Click on the “Test Connection” button to verify the connection.
8. If the connection is successful, click on the “Add” button.
9. The SQL Server data source is now added to Gateway Power BI.

Repeat these steps for any other data sources you want to add.