Intermittent Refresh Issues

PowerBI_Noob90 · ‎12-20-2023

I often get error messages when I attempt a manual refresh after manipulating tables in Power Query (i.e. after I select "Apply") but what's odd is that it usually works if I just re-attempt it once or twice.

This isn't a big deal when I'm creating or editing reports but I am concerned about what happens when I publish them because I'm assuming the same thing can/will happen. If I set an automatic refresh cycle and this same error occurs during an automatic refresh, will Power BI be smart enough to re-attempt the refresh until it works? If not is there any other solution besides setting multiple auto-refreshes within a few minutes of each other in case the first one or two fail?

Anonymous · ‎12-20-2023

Hi @PowerBI_Noob90 ,

Can you please share some more detail information about this issue? They should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

PowerBI_Noob90 · ‎12-21-2023

It connects to Oracle tables.

Anonymous · ‎12-25-2023

HI @PowerBI_Noob90,

Which error message are you faced? Can you please share more information about these? If this error message is related to refresh timeout, you can also try to modify timeout property in data connector.

Data refresh in Power BI - Power BI | Microsoft Learn

In addition, the refresh operations will retry 4 times instead of disable this refresh immediately when the refresh processing failed.
After retry operations still not succeed, power bi will disable the refresh and required you to verify and confirm the refresh settings.

Solved: PBI scheduled Refresh is automatically disabled af... - Microsoft Fabric Community

Regards,

Xiaoxin Sheng