Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Tsarev_Artem
New Member

problems with scheduling updates

Good afternoon. I have encountered such a problem that updating reports on a schedule causes such an error, despite the fact that manually clicking on the update, it turns out without problems.

The data is taken from the PostgeSQL server with the help of conection to data gateway On-premises data getaway because i need VPN to have access to data. please tell me what the problem may be and how to fix it?

Tsarev_Artem_1-1676466042686.png

 

Tsarev_Artem_0-1676466009224.png

 

1 REPLY 1
jaweher899
Super User
Super User

The error message you are seeing in your Power BI report indicates that there is an issue with the on-premises data gateway that is used to connect to your PostgreSQL server. There are a few things that you can check and try to resolve this issue:

  1. Ensure that the on-premises data gateway is running: Check that the gateway is up and running by navigating to the "Data Gateways" section in the Power BI Service, and verifying that the status of the gateway is "Running".

  2. Check the connection settings: Ensure that the connection settings for the PostgreSQL data source in the on-premises data gateway are correct, including the server name, database name, and credentials.

  3. Verify that the gateway is configured to allow scheduled refresh: Check that the on-premises data gateway is configured to allow scheduled refresh for the dataset associated with your report.

  4. Check for firewall and VPN issues: Verify that the firewall settings on your computer and network are not blocking the on-premises data gateway, and ensure that your VPN connection is stable and active.

  5. Update the on-premises data gateway: If the above steps do not resolve the issue, try updating the on-premises data gateway to the latest version.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.