cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlexZ
Frequent Visitor

There was a problem refreshing your dataflow

Today I got the mail: Refresh failed: Your Appeee dataflow couldn’t be refreshed.

AlexZ_0-1620376435689.png

It's not the first time I've got this mail though, but what does it mean? ... and how can I avoid it?
To make things a little bit more interresting. Sometimes the refresh automaticaly triggers a second time and then it completes successfully, but on other times it doesn't trigger a second time.

Today it triggerd again.

AlexZ_1-1620376715703.png

Last week it timed out.

AlexZ_2-1620377038912.png

The week before that it Failed but it didn't trigger a second time.

AlexZ_3-1620377116523.png

 

When it fails it's not allways on the same part of the flow, but it's allways an internal error.
The data for the dataflow are json files stored in an Azure Blob storage.

 

Kind regards,

 

AlexZ

3 REPLIES 3
v-deddai1-msft
Community Support
Community Support

Hi @AlexZ ,

 

I have found a similar issue. Would you please try to use the workaround:  setting the schedule to half an hour or an hour later than the current time (not more than that).

 

Please refer to the similar post: https://community.powerbi.com/t5/Service/Data-Flow-scheduled-refresh-triggering-multiple-times/m-p/1...

 

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

 

Best Regards,

Dedmon Dai

Hi @v-deddai1-msft ,

 

Thanks for your reply.

I've taken a screenshot from the workspace.

AlexZ_0-1620716444515.png

As you can see the workflows are running at different times and the Appeee flow didn't have any problems today but the Appeee_GMBH flow which runs 01:30 hours earlier failed. So I don't understand why changing the schedule time should fix the problem. Any of these flows could just run fine for a couple of weeks or even months without any problems, before it just fails again for no apparent reason. Nevertheless I will change the schedule.

 

These four flow are actualy the same except for a filter specifying the part of the company.

Since I didn't had access to premium they are running side-by-side.

But as of this week my boss approved on using Power BI Premium, so I will change this to use one master flow doing the basic modeling. And then used linked entities to filter the data for the different user groups.

So hopefully that will fix things for me.

 

 

The error message states there is something wrong with one or more entities or dataflow capabillities were unavailable. If there was a problem with the entities it would fail every time since the source data isn't changed. So it is safe to rule that part out.

 

Now the question still remains: What does dataflow capabillities were unavailable mean?

 

Hi @AlexZ ,

 

If you don't use Power BI Premium, all your dataflow will use resource shared with others. Because your issue is intermittent. I assume it is caused by resource contention.

 

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

 

Best Regards,

Dedmon Dai

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors