Forum Discussion
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
Super UserHi 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,
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.