Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

DataFlows refreshes, but report doesn't react

Hi, 

 

I've got a DataFlow configured and I set the refresh to 6.00 AM. This Dataflow is connected to a dataset and I scheduled dataset refresh for 7.00 AM to avoid delays. I also created an email subscription for a report connected to a dataset with a refresh trigger, so the email should go once a day after the dataset is refreshed. 

 

And here's the problem: both DataFlow and dataset show the refreshed status, an email from a report was sent, but there was no new data in the report. I can see in the DataFlow table that new data has been imported, but report still doesn't show any. 

 

Dataflow

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Ideally you want to trigger the dataset refresh when the dataflow refresh completes successfully - for example via Power Automate.  Then you have to wait for the dataset to refresh before your report will show the latest data.  You can also do that in Power Automate but you will have to implement the polling yourself.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi lbendlin , 

       

      Thanks for the reply, however that's not the point. I can see the DataFlow is refreshed - meaning, when I look inside the tables I see new data. The problem is that the dataset and the report don't see the new data and I have constantly one day delay. 

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        As I said - you are likely initiating the dataset refresh before the dataflow refresh has finished.