Conditional Data Refresh - (Proceed table refresh only if Conditions are met)
Short Desc: Often I would like to refresh my report only if certain conditions in the DB are met. Like DID my Daily table Refresh complete? Is the latest Prices available? Are all my 100 products updated before I can report them?
Long Desc: Like in many enterprises, there is never a set time when a ETL/Database refresh might complete. In my organization we have several dataset that complete at different time depending on the region and size of the data. So when I schedule my reports, I would like to check if its really a good time to report my report at all or should I continue reporting the previously refresh data?
It would be great if "Edit Queries" windows provided a step where I can input for example, a SQL statement like "SELECT STATUS from TBLETLSTATUS" and check if the returned status is "COMPLETE" or "INCOMPLETE" only then proceed to run the next step of refreshing the data.
Or to take this one level higher, allow us to have a Universal Condition, where I proceed with the refreshing ALL tables only if certain conditions are met.
CHECK : CRITERIA 1 - PASS --> CRITERIA 2 - PASS --> REFRESH TABLES
KEEP Previous data
Firstly this reduce load on PowerBI Service to load unwanted/incomplete data
Secondly, Devs have more control on what data is appearing on their reports
Hope others find this exciting too
Can this only have a few votes? There must be some other similar topic. I would like this to gather snapshots - to have 12 monthly dataflows that refresh daily during "their" current month and then don't refresh again, so that the data is essentially cached off. 'off month' refresh could be forced on demand, but the schedule would otherwise be subverted.