Forum Discussion
gateway can solved firewall error?
Yes on-premises gateway will mak it more stable and may help you in speed up processing too.
You can install your enterprise gateway on the same server as the datasource but keep a note on the ports that are required to be opened on the server to make the gateway work as it needs to communicate outside. If your report is already published in a workspace you don't have to do anything, just create a gateway and register it then you will see an option to ocnnect your datasource to gateway and just add it there.
You can find more details here:
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-communication
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-indepth
Sorry I didn't understand your question, can you explain it in detail?
After installing the gateway you will have to create a datasource on gateway which enable it to connect with that particular datasource like particular SQL database with authentication details so that ways its in a controlled way and also you can restrict access to specific people t use it if you want.
nitishsh91 From my understanding i will:
- Download enterprise-gateway on my machine data source.
- and then in my local computer i will work normally with getting the data (from ODATA).
- Publish it to the Service.
- In the source settings i will add my source to my gateway (from the PBI service).
Is it correct work system or i didnt understood correctly? What are the risks if i will install the enterprise gateway on the same maschine that my data source on it?
In addition, if i will download BI Desktop on my data source maschine, is it reccomended or not?
My biggest problem now is that the refresh (mainlly the first) in the service take too much time (small files, refresh takes sometimes 4 hours).
Thank you!