cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bcdobbs
Super User
Super User

Dataflow Issue Fixed by Dropping Workspace to Pro and then back to PPU

Hi,
I have a really odd issue with a data flow.

 

It failed over night and looks like it basically timed out:

bcdobbs_0-1638953026133.png

The data flow is as simple as it comes, direct load from a set of On Prem DW tables with no ETL. Normal run time is around 30 seconds in PPU so data volume is not massive.

 

I refreshed it again with SQL Server Profile open and saw nothing reaching it.

 

The solution I found was to drop the work space out of premium per user to pro. Refresh (which worked) and then restore it to PPU. Everything is now working.

 

Assume this is related to something in the compute engine but no idea.

 

Thoughts welcome.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
1 ACCEPTED SOLUTION
v-janeyg-msft
Community Support
Community Support

Hi, @bcdobbs 

 

vjaneygmsft_0-1639361395296.png

Indeed, there should be some unexpected situations when refreshing. But the specific cause can't be seen from your description. The troubleshooting needs the additional gateway log when refresh fails. 

If you can solve the problem by switching the workspace licence type, the problem is not big. If this problem still occurs, describe and solve it in detail.

And I also find a similar issue has been submitted internally. Internal ICM ID:277034883. If there is any news, I will update it here.

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

 

Best Regards,
Community Support Team _ Janey

View solution in original post

1 REPLY 1
v-janeyg-msft
Community Support
Community Support

Hi, @bcdobbs 

 

vjaneygmsft_0-1639361395296.png

Indeed, there should be some unexpected situations when refreshing. But the specific cause can't be seen from your description. The troubleshooting needs the additional gateway log when refresh fails. 

If you can solve the problem by switching the workspace licence type, the problem is not big. If this problem still occurs, describe and solve it in detail.

And I also find a similar issue has been submitted internally. Internal ICM ID:277034883. If there is any news, I will update it here.

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

 

Best Regards,
Community Support Team _ Janey

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.

Top Solution Authors
Top Kudoed Authors