Forum Discussion
Helper IIIPower BI Report Server - Data source connections
niyati_61 wrote:
1) Question, could this be done on my local PC itself? Like connected the ports from my local PC to the Oracle Server. But could not go with this option for security reasons, and that for the data to be connected and schedule refreshed it always has to be in the domain (and if you work from home, you need your vpn turned on to access the data - so that would disrupt the schedule refresh).
Typically you would do this on your local PC first, installing the Oracle drivers there and getting the report working. Once that is done you would then also install the drivers on report server so that you could do a scheduled refresh. Using a VPN only affects the connection between your laptop and the work network, it should not have any affect on the Report Server computer so scheduled refresh should be unaffected.
niyati_61 wrote:
2) I checked with IT if the shared folder could be created in my own PC itself instead of the report server PC, but it wasn't an option allowed for security reasons, and that it is better for the data folder to be in the domain and a common place if another user needs to access it. But, could it this shared folder have been created on my own local PC?
while technically you could create a shared folder on your PC it is general a very bad idea. If your machine is not connected to the VPN or you need to reboot or you are travelling between home and the office, then that share would be offline and any scheduled refresh would fail. It is much better to have shared folder run on centralized servers that are owned and managed by IT.
niyati_61 wrote:
Is that how it usually works? For data source connection, and for schedule refreshing on the report server web portal, do data source connections have to be done on the report server pc itself, and not on my own local user pc?
No, normally no users do anything on the Report Server. They generally do not have access to logon to the Report Server and they definitely do not run resource intensive applications like Power BI Desktop. Generally all report building is done on local PCs and then the final reports are uploaded to Report Server
Super User
niyati_61 wrote:
1) Question, could this be done on my local PC itself? Like connected the ports from my local PC to the Oracle Server. But could not go with this option for security reasons, and that for the data to be connected and schedule refreshed it always has to be in the domain (and if you work from home, you need your vpn turned on to access the data - so that would disrupt the schedule refresh).
Typically you would do this on your local PC first, installing the Oracle drivers there and getting the report working. Once that is done you would then also install the drivers on report server so that you could do a scheduled refresh. Using a VPN only affects the connection between your laptop and the work network, it should not have any affect on the Report Server computer so scheduled refresh should be unaffected.
niyati_61 wrote:
2) I checked with IT if the shared folder could be created in my own PC itself instead of the report server PC, but it wasn't an option allowed for security reasons, and that it is better for the data folder to be in the domain and a common place if another user needs to access it. But, could it this shared folder have been created on my own local PC?
while technically you could create a shared folder on your PC it is general a very bad idea. If your machine is not connected to the VPN or you need to reboot or you are travelling between home and the office, then that share would be offline and any scheduled refresh would fail. It is much better to have shared folder run on centralized servers that are owned and managed by IT.
niyati_61 wrote:
Is that how it usually works? For data source connection, and for schedule refreshing on the report server web portal, do data source connections have to be done on the report server pc itself, and not on my own local user pc?
No, normally no users do anything on the Report Server. They generally do not have access to logon to the Report Server and they definitely do not run resource intensive applications like Power BI Desktop. Generally all report building is done on local PCs and then the final reports are uploaded to Report Server