Adding a gateway to a PowerBI Dataset (DirectQuery for Power BI datasets)

[Anonymous]

Hi,

We are trying to use the new preview feature - DirectQuery for Power BI datasets

When publishing the report to PowerBI Service we are asked to configure a gateway for the PowerBI dataset.

Does anyone know how to do this as I can't find any documentation on setting up gateways for the PowerBI dataset?

[v-yangliu-msft · Accepted solution]

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.

[marcosdatawalt]

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

[aj1973]

Hi @Anonymous 

did you follow these steps?

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install