Forum Discussion

dcrow5378's avatar
dcrow5378
Icon for Resolver I rankResolver I
1 month ago
Solved

Service Refresh Constant Errors

Does anyone else feel like all they do lately is babysit refresh errors? Currenlty running 300.326.10 (about to download 300.326.11).  I've been doing this along time and lately, probably most of 2...
General Comment
Need Help
  • dcrow5378's avatar
    dcrow5378
    1 month ago

    Follow up: Yes, we always use the latest gateway and we have gone through and load balanced our refresh schedule.  As of last week the machine hosting the On-premises Data gateway was pegged.  Our engineers have moved from a B Series VM to a D series VM.  This move has proved to be very successful and refresh failures dropped dramatically.  Next step we will either add additional gateways or move to a VNet Gateway.
    Thanks all for the responses.  FYI running F32 capacity.

Ray_Minds's avatar
Ray_Minds
Icon for Solution Supplier rankSolution Supplier
1 month ago
Solution  : 

There are some steps which we can use to debug it.

 
1. Please close all the online files which we are using or calling directly in the Power BI , that might also cause the semantic Model failure
1. Look for common failure points:-  Are the errors always the same service, dataset, gateway, credential, or dependency? If the Most of failures come from one root cause, fixing that has a much bigger impact than chasing individual refreshes.
 
2. Review refresh schedule:-  If many jobs are competing for the same resources, staggering them can reduce transient failures.
 
3. Check gateways and authentication:- Gateway status should Active and also check credentials expiration of gateway or overloaded gateways if you're using in the Semantic model.
 
4. Use monitoring and alerts :-  If your platform supports failure notifications or APIs, automate detection so you're only involved when intervention is actually needed.
 
5. Data Volume and Data Types or bad column /data  :- We need to validate the 2026 New data, which should proper data type defined and remove the unnecessary columns which is not used.
 
6. Collect error statistics :-  Rather than relying on the feeling that "it's always happening," track refresh success rates over a week or two. If you can show that success dropped from, say, 99% to 92% after a particular version, it gives you much stronger evidence when opening a support case.
 

7. capacity volume exceed :- Please validate the utilization of workspace capacity volume , it should not utilize 100 % of capacity during refresh , that might also cause the refresh failure.

v-aatheeque's avatar
v-aatheeque
Icon for Community Support rankCommunity Support
1 month ago

Hi dcrow5378 

Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.