Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors