Issue with DataFlow Refreshing for PPU

[Imrans123]

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. 

[v-zhangti · Accepted solution]

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.

[Imrans123]

 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]

Hi @Imrans123 ,

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

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

[Imrans123]

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!