Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

data gateway- personal mode or not ?!!!

I have a dashboard in Power Bi service that retrieves the data from the Microsoft SQL Server database. The dashboard should be shared between the users in the organization and I need to make sure tha...
Need Help
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    If you want to share a reports then you can still do it but if you want to create a multi user work environment then you need the on-premises gateway. Also the personal gateway doesn-t work with direct query and live connections

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Anonymous wrote:

I have a dashboard in Power Bi service that retrieves the data from the Microsoft SQL Server database. The dashboard should be shared between the users in the organization and I need to make sure that the users will see the current data when they view the dashboard. 

 

Which one is the correct solution : 

 

1- To deploy an on-premises data gateway. Import the data by using the DirectQuery data Connectivity mode. 

OR

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

Correct answer is 

 

1- To deploy an on-premises data gateway. Import the data by using the DirectQuery data Connectivity mode. 

 

Details about Gateway: https://community.powerbi.com/t5/Service/On-Premise-Data-Gateway-or-Personal-Gateway/td-p/484468