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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: data gateway- personal mode or not ?!!!

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

 


 


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


Proud to be a Datanaut!  

7 REPLIES 7
ibarrau Established Member
Established Member

Re: data gateway- personal mode or not ?!!!

Hi there. You are a little confused. First of all you have a way to connect to data. It can be imported data or direct query.

 

Import data has up to 8 schedule refreshes in a day and the best thing I think it has, is that you won't compromise the database performance because it will be a complete model in microsoft ram performance. It will only query sql server the times you schedule it.

 

Direct query let you have a 15 minutes cache where it will query your database every time looking for aswers. This approach is not recommended to do it in the production database. For this you should have a datawarehouse hosted in another machine.

 

After that you have the gateways. I would recommend on premise data gateway with import data. This runs a windows service. The personal data gateway is an app for one person and not a service. The best for production is NOT to use personal way.

 

Regards,

Super User
Super User

Re: data gateway- personal mode or not ?!!!

Go with the first option if feasible

 

 


 


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


Proud to be a Datanaut!  

Re: data gateway- personal mode or not ?!!!

Dear @ibarrau

Thank you for the answer. I completely understand all you just explained. 

I am aware that as far as it is possible we should use the import mode over the direct query, and other stuff. 

 

What made me ask this question is the mock exam I saw on the internet which I believe the answer for it is wrong. But I just wanted to make sure that I was right guessing that the Personal way is not the correct selection. 

Re: data gateway- personal mode or not ?!!!

@LivioLanzo

yes, I agree with you. Because we want to share it with other users as well. right?

Super User
Super User

Re: data gateway- personal mode or not ?!!!

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

 


 


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


Proud to be a Datanaut!  

Community Support Team
Community Support Team

Re: data gateway- personal mode or not ?!!!

Hi  @elahemeydani,

 

Agree with LivioLanzo.

 

If you have solved your problem, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

If you still need help, please feel free to ask.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sshuford Frequent Visitor
Frequent Visitor

Re: data gateway- personal mode or not ?!!!

I saw the same thing on two different practice test.  I believe the answer is wrong, as it wants you to do a driect query on a personal gateway.