I am new to Power BI. we need a urgent help.
We have developed a dashboard in a server with local DB and this server is not on internet. now we have published the dashboard and need to schedule for data refresh. we are trying to do that using gateway but stuck somewhere.
Kindly help us.
Just login into your Power BI Service and Click on the settings option on top of your PBI Service and download Gateway Installer from there.
Once downloaded, Install the same in your Server (If the source is from your local system, then install it in your local else install the exe in your Database system).
While installing choose option "Enterprise Data Management Gateway" to be configured with the Passcode (this is nothing but security level code for future use)
You can configure the gateway with the credentials to connect your source system with the service account. Then, you are good to go to add the data source in Power BI service for the same Gateway configured.
Add the Data source with the credentials and schedule the refresh of your report in the given frequency of time.
For further clarifications, you can refer the below URL.
Internet not required. You can connect your server through your organization network.
or, take Remote Desktop to the server where your database exist.
Do you have internet in your servers? If yes, then you can install it without an error.
Or, could you please explain at which step you get this exception?
You should have internet in your server to configure the gateway.
please refer the below URL. Anywhere you configure your Gateway, you should require Internet.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!