Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dataflow refreshes

Hi, I have set a dataflow that connects to SharePoint online And then my dataflows connect to Power BI dashboard as a dataset My questions is: I'm already having a refresh schedule for dataflows DO I also need a refresh schedule for my dataset(that connects to this dataflow)?

  • If your dataset is doing direct query to the dataflows that already have a refresh schedule, no additional refresh should be needed.  You should be able to add something to your SharePoint list to test that out to confirm easily.

    Regards,

    Pat

     

3 Replies

  • themistoklis's avatar
    themistoklis
    Community Champion

    Anonymous 

     

    You need to have two refreshes (if i understood your problem correcty).

    One refresh scheduler that updates the data to the target dataset and another refresh scheduler ( in PowerBI side) that gets the latest data from the dataset.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Im using direct query to fetch data from dataflows

      • mahoneypat's avatar
        mahoneypat
        Microsoft Employee

        If your dataset is doing direct query to the dataflows that already have a refresh schedule, no additional refresh should be needed.  You should be able to add something to your SharePoint list to test that out to confirm easily.

        Regards,

        Pat