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 Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

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.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.