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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Imrans123
Advocate V
Advocate V

Issue with DataFlow Refreshing for PPU

Hello, 

 

I was wondering if anyone is having an issue similar to mine right now? I have a PPU account and a premium workspace with multiple dataflows using SQL Server and native queries to bring in the data. I've had them on for automatic refresh and up until today, everything was working as it should.

 

Today suddenly, it won't refresh. When i click refresh, it beings refreshing, but doesn't do anything. While refreshing, when I click download log, it doesn't show any table. Just a blank csv with the headers the refresh log usually has. I went into the data flow, check that every table loads, hit save and close and it evaluated all tables successfully as well. But it won't refresh. 

 

Anyone had this problem before?

 

Note: This problem is prevalent in only one PPU workspace. I have another PPU workspace where my dataflows are refreshing properly. In addition, I have my regular pro workspaces where the dataflows are all refreshing. 

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @Imrans123 

 

Are there hints and details of failed refreshes?

 

You should always ensure that basic requirements for refresh are met and verified. These basic requirements include:

  • Verify the gateway version is up to date
  • Verify the report has a gateway selected - if not, the datasource may have changed or might be missing

 

You can also refer to the following documents.

https://docs.microsoft.com/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios 

https://docs.microsoft.com/power-bi/transform-model/dataflows/dataflows-understand-optimize-refresh 

 

Best Regards,

Community Support Team _Charlotte

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

View solution in original post

4 REPLIES 4
v-zhangti
Community Support
Community Support

Hi, @Imrans123 

 

Are there hints and details of failed refreshes?

 

You should always ensure that basic requirements for refresh are met and verified. These basic requirements include:

  • Verify the gateway version is up to date
  • Verify the report has a gateway selected - if not, the datasource may have changed or might be missing

 

You can also refer to the following documents.

https://docs.microsoft.com/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios 

https://docs.microsoft.com/power-bi/transform-model/dataflows/dataflows-understand-optimize-refresh 

 

Best Regards,

Community Support Team _Charlotte

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

 Hey Charlotte, 

 

Thanks for your response. I did check those basic requirements at the time and they were fine. The DataFlow eventually started working again without any intervention from my side.

 

Thanks! 

collinq
Super User
Super User

Hi @Imrans123 ,

 

If you go to the Resources - Support - Overview on this page you will see that there are some dataflow issues right now:  

collinq_0-1653147669535.png

 

I would suggest reading that whole article to see if it pertains to you.

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Hey Collin, 

 

Yeah, I went through the article and try to maintain best practices whereever possible. Must have been downtime as it just started working for me randomly again. 

 

Thanks! 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors