Configure the connection to the data source (DirectQuery)

[Anonymous]

There is a dashboard in the Power BI service that retrieves data from a Microsoft
SQL Server database. Planning to share dashboard between the users in your
organization.

Requirement is users should see the current data when they view the dashboard.

How should you configure the connection to the data source?

1-Deploy an on-premises data gateway. Import the data by using the DirectQuery Data
Connectivity mode.

2-Deploy an on-premises data gateway (personal mode). Import the data by using the
DirectQuery Data Connectivity mode.

When I should go with option 1 & when with 2 and what would be advantage of 2 over 1?

My friend is arguing 2 is right for above requirment.  

[v-yuta-msft · Accepted solution]

@Anonymous ,

If you are not using Fast Combine, I would suggest you to install on-premises data gateway. Actuallu, there're several limitations in gateway personal mode, please refer to:

https://docs.microsoft.com/en-us/power-bi/service-gateway-personal-mode#limitations-and-considerations

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.