Forum Discussion
Please help with Dataflow(s)
Yes, I think that would be the most efficient setup i.e. one 'base' data flow that brings in everything, then a number of other tables that reference (not duplicate) the base dataflow, but are filtered as required for the other different reports.
If your source that feeds the dataflow is an SQL server, I think the most efficient in terms of load may be connecting directly to the source from each report, as you could then make full use of query folding and staggered refresh times, but YMMV.
Pete
Thank you. Yes, we're on premium capacity.
To make sure I understand, what do you mean by "filter the reference result to your requirements"? Simply filter the dataflow itself to what's needed in the dataset?
Edit: Are you referring to having a 'base' dataflow, then create filtered dataflows sourced from it?
Yes, I think that would be the most efficient setup i.e. one 'base' data flow that brings in everything, then a number of other tables that reference (not duplicate) the base dataflow, but are filtered as required for the other different reports.
If your source that feeds the dataflow is an SQL server, I think the most efficient in terms of load may be connecting directly to the source from each report, as you could then make full use of query folding and staggered refresh times, but YMMV.
Pete