Forum Discussion

Imrans123's avatar
Imrans123
Advocate V
4 years ago
Solved

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. 

Need Help
Show and Tell

4 Replies

  • collinq's avatar
    collinq
    Super User
    4 years ago

    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's avatar
      Imrans123
      Advocate V
      4 years ago

      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! 

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    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's avatar
      Imrans123
      Advocate V
      4 years ago

       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!