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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Problem with Scheduled Refresh

I'm currently encountering an issue with the Scheduled Refresh feature in the Power BI service. Notable points to consider include the following:

  • The refresh process exhibits intermittent behavior, succeeding at times and failing at others. This inconsistency is mirrored when attempting an on-demand refresh as well.

  • The error message received during these occurrences is as follows:
    {"error":{"code":"DM_GWPipeline_Client_GatewayUnreachable","pbi.error":{"code":"DM_GWPipeline_Client_GatewayUnreachable","parameters":{},"details":[],"exceptionCulprit":1}}}

  • Our server is configured with an 8 GB RAM and a 2-core processor. It hosts both an on-premise data source and an On-premise data gateway.

  • The license type utilized is 'Pro.'

  • Additionally, it's important to note that our server is concurrently running several other services.

This issue poses a unique challenge, and I'm actively investigating potential solutions to ensure consistent and reliable refreshes for our Power BI reports.
@ITSupport @MicrosoftLC I would greatly appreciate any insights you might have on resolving this issue.
Up to this point, we have examined the following
Gateway Health Check: Conducted a thorough health check of the On-premise data gateway to ensure it's operating optimally and is correctly configured.

Network Considerations: Assess network connectivity between the server and the On-premise data source to rule out any intermittent disruptions.

Gateway Updates: Ensure that the On-premise data gateway is updated to the latest version, as updates might include bug fixes or improvements.

Log Analysis: Analyze logs generated during the refresh failures to identify patterns or potential triggers.

Gateway Configuration: Review the gateway configuration settings, ensuring they align with the data source requirements.

Your expertise and guidance in resolving this matter would be highly valuable. Thank you in advance for your assistance!"

1 REPLY 1
StefanoGrimaldi
Resident Rockstar
Resident Rockstar

try to replicate the error with a new simple dataset, also check if your dataset have a parameter in the queries that could be not getting the value correctly and its sendining it to the source to get data and them failing. also unistall and reinstall the gateway to elimanate any posible corruption on the gateway. 

 

also during the log analysis does the request got to the gateway at the exact time you request the manual refresh? there could be fluctuation on the conection or internet that didnt even log the intent on the gateway. 

 

this are just a couple of ideas cause the error isnt much exact. also you could open a support ticket for microsoft, they could do a extra analysis for you on the power bi services logs. 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.