DirectQuery and Power BI Service

[Anonymous]

I have a Power BI Desktop project that uses DirectQuery to access an on-premises
Microsoft SQL Server database.

From Power BI Desktop, you can query the database. But When I publish the Power BI Desktop project to the Power BI service, the visualizations cannot display the data. What should I do to resolve the issue?

1. Locate the published dataset for the project in the Power BI service and configure the
data source credentials.
2. Install the on-premises data gateway (personal mode) and republish the project.
3. Install the on-premises data gateway and configure a data source.

I think 1 is correct but why not 3..? Please can someone explain this?

Thank you!

[GilbertQ]

Hi there

In order to use DirectQuery you need to install and configure the On-Premise data gateway in Enterprise mode.

Once that is done, then create a new data source in the Power BI Service to the SQL Server Database.

Once that is done, re-publish your PBIX file and once it has been published it should let you know that it has connected to the Gateway.

https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-sql

[Anonymous]

---

@GilbertQ wrote:
Hi there

In order to use DirectQuery you need to install and configure the On-Premise data gateway in Enterprise mode.

Once that is done, then create a new data source in the Power BI Service to the SQL Server Database.

Once that is done, re-publish your PBIX file and once it has been published it should let you know that it has connected to the Gateway.

https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-sql

---

Thanks for your response.  My question was which is correct from given options?

I have a Power BI Desktop project that uses DirectQuery to access an on-premises
Microsoft SQL Server database.

From Power BI Desktop, you can query the database. But When I publish the Power BI Desktop project to the Power BI service, the visualizations cannot display the data. What should I do to resolve the issue?

1. Locate the published dataset for the project in the Power BI service and configure the
data source credentials.
2. Install the on-premises data gateway (personal mode) and republish the project.
3. Install the on-premises data gateway and configure a data source.

[GilbertQ]

Hi there

I thought that I had explained it in my response and the associated link?

[Anonymous]

---

@GilbertQ wrote:
Hi there

I thought that I had explained it in my response and the associated link?

---

Still not clear, just say option 1 is right or option 3..? 

[GilbertQ · Accepted solution]

Option 3 would be the way to go.