Answer
- Use the workflow type of “BI Blend, Workspace”. This way you can import/transform the data and then immediately afterwards use a dashboard to query review the data on each cycle.
- If the workflow tracking frequency is monthly then the a new BI Blend table is created for each month. If the workflow tracking frequency is yearly, then the BI Blend table is created for the year, with periods in a column.
Source: Office Hours 2019-12-12 Partner Enablement