DirectQuery and Power BI Service

---

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.