cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

DirectQuery and Power BI Service

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: DirectQuery and Power BI Service

Option 3 would be the way to go.

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog
5 REPLIES 5
Super User
Super User

Re: DirectQuery and Power BI Service

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

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog

Re: 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.

Super User
Super User

Re: DirectQuery and Power BI Service

Hi there

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

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog

Re: DirectQuery and Power BI Service


@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..? 

Super User
Super User

Re: DirectQuery and Power BI Service

Option 3 would be the way to go.

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog