Skip to main content

Power BI

New

Allow tables within a dataflow to refresh on separate cycles

Vote (5) Share
Clayton Holderfield's profile image

Clayton Holderfield on 25 May 2022 13:57:08

We are starting to use dataflows in my organization. It would be very helpful to be able to set the refresh cycle for each table in a dataflow rather than having all tables follow the same schedule.


Here is our example use case. We have a dataflow that contains a sales data table from an ERP. That table should refresh every thirty minutes. In the same dataflow, we have a table with sales adjustments from the general ledger in the accounting system. That table should refresh once per day. Within the dataflow, we merge the sales data and general ledger tables to get a total sales with adjustments table.


We have considered using linked tables and have the sales data table and the general ledger table in their own dataflows, but since they are stored in a single workspace, a refresh of the sales data table triggers a refresh of the general ledger table.