Forum Discussion
Adding a gateway to a PowerBI Dataset (DirectQuery for Power BI datasets)
Hi Anonymous ,
You can do：
1. After publishing to services, you need to select Setting-Datasets through the gear in the upper right corner to connect to the gateway
2. Expand the gateway connection, and verify that at least one gateway is listed, expand the toggle button to view the data source, and then select the "Add to gateway" link
3. On the "Data Source Settings" tab on the "Gateway Management" page, and then select "Add
4. On the Datasets tab, expand the Gateway connection section again. Select the data gateway you configured, which shows a Status of running on the machine where you installed it, and select Apply.
This is the related document, you can check it out:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
You can do：
1. After publishing to services, you need to select Setting-Datasets through the gear in the upper right corner to connect to the gateway
2. Expand the gateway connection, and verify that at least one gateway is listed, expand the toggle button to view the data source, and then select the "Add to gateway" link
3. On the "Data Source Settings" tab on the "Gateway Management" page, and then select "Add
4. On the Datasets tab, expand the Gateway connection section again. Select the data gateway you configured, which shows a Status of running on the machine where you installed it, and select Apply.
This is the related document, you can check it out:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
How can i get the username and password for that gateway?, I'm having the same trouble connecting to a Power BI Service dataset using DirectQuery and I'm stuck because i don't know how to get those credentials.
Regards,
M