Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
In plain terms, I haven't been able to find a straight forward answer to how to set up a Data Source so it does not need the associated Gateway computer to be on.
A gatewaay was installed on my computer from the tutorials taken about Power BI service. However, when I publish now, my datasource always needs a gateway computer on. Is there a way to let the server itself do the refresh? If so, why would we want a gaeway instead of having the server do it? We are on an on-prem enterprise solution I believe. Notice the greyed out Use data gateway option below:
Thank you in advance
Solved! Go to Solution.
Hi @jribs ,
You need to have a gateway if you are having the service refresh the data. You need to set up a Enterprise Gateway on a server that stays "up" all of the time and not use a Personal Gateway. Because, as you state, your computer has to be on and up all the time for a Personal Gateway to work. As @aj1973 states, you have to use a gateway if you want the service to use schedule refreshes AND if you data is inside your organization's firewalls.
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hi @jribs ,
You need to have a gateway if you are having the service refresh the data. You need to set up a Enterprise Gateway on a server that stays "up" all of the time and not use a Personal Gateway. Because, as you state, your computer has to be on and up all the time for a Personal Gateway to work. As @aj1973 states, you have to use a gateway if you want the service to use schedule refreshes AND if you data is inside your organization's firewalls.
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hi @jribs
If you have access to the server then install Gateway Entreprise in it. You always need a Gateway to connect Power service to your server
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.