Forum Discussion
Partial Updates
Good!
I have a report in PBI that accesses two tables, one from sql and the other is an excel hosted on a sharepoint.
This power bi has a scheduled update every day in the morning plus one more update they do in the afternoon
The thing is, the afternoon update is to refresh the excel data... Is there a way that when you update the report for the second time in the day, you only process ONE of the two tables and not both?
They both use the same schedule, but if you want you could put one of the two queries into a dataflow and pull it into your model from the dataflow. The dataflow has its own refresh schedule, so no matter what time your data model refreshes, the data it receives will only be as fresh as what's available in the dataflow. It's like an intermediary table between your source and the semantic model.
1 Reply
They both use the same schedule, but if you want you could put one of the two queries into a dataflow and pull it into your model from the dataflow. The dataflow has its own refresh schedule, so no matter what time your data model refreshes, the data it receives will only be as fresh as what's available in the dataflow. It's like an intermediary table between your source and the semantic model.