Dataflow not refreshing, no errors

[gbz1]

Hello all,

We have a dataflow that refreshed at 1am on 5/21 as scheduled, and has not refreshed since. Manual refreshes do not register either on the page. There are no errors, nothing to indicate what is going wrong. We did not alter the flow before the issue started, although I did make some changes the morning of 5/21 but it still should have refreshed earlier in the morning. I've made several edits to the flow, saved it, and tried the refresh that pops up there. Still nothing. Here is a not too helpful screenshot since I have no errors to share. Any ideas on what is causing this? I could find no mention of an outage.

[BL_consultant]

Hi, I have run into this issue twice now during this year. In both cases, the only working solution was to export the dataflow and import it back as another copy. Then replace the old dataflow from the reports/semantic models with this new one. And also in both cases the refresing was done using Power Automate (as a part of a bigger synchronized refresh scheduling). 

[SaiTejaTalasila]

Hi,

Sometimes schedule refresh option gets disabledand it causes the issue.I recommend you to choose power automate flows for triggering your dataflows and semantic models.

Thanks,

Sai Teja 

[hackcrr · Accepted solution]

Hi, @gbz1 

You can try the following troubleshooting steps:
1. Check data source connections: Make sure that all data source connections that the data stream depends on are valid and have not been accidentally changed or disconnected. If the data sources are databases or APIs, make sure that they have not undergone any changes (e.g., password changes, IP whitelist changes, etc.) that might prevent the data stream from accessing them.
2. View the data flow history: In the Power BI service, navigate to the Data Flow page and view the History section. Even if there are no errors, there may be some logs or messages about refresh attempts that may provide clues.
3. Check data flow dependencies: If the data flow depends on other data flows or datasets, make sure that those dependencies are also okay and that they also refresh successfully.
4. Check Power BI service status: Although you said you did not find information about the service outage, it is always good to check the status of the Power BI service again. Sometimes, even small service outages or performance issues can affect a refresh.
5. Check gateway configuration (if applicable): If your data source is on a local or private network and you are using a data gateway, make sure that the gateway is configured correctly and is running.
6. Check Capacity Settings: If you are using Power BI Premium capacity, make sure that the capacity has enough resources to handle refresh requests. The capacity may have reached its resource limit, causing refresh requests to be delayed or rejected.

7 Try to recreate the data stream: If all else fails and you are confident that the problem is not with the data source or configuration, then trying to recreate the data stream may be a last resort. Of course, before doing so, make sure you have backed up all the necessary data and configuration.

I hope these suggestions will help you solve your problem!

Best Regards,

hackcrr

If this post helps, then please consider Accept it as the solution and kudos to this post to help the other members find it more quickly

[gbz1]

I checked all applicable steps you posted and nothing helped, so unfortunately I just recreated the flow and updated our PBI reports to use the new dataflow.