cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors