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
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
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