Matthew Roche gives some advice on how large to make artifacts in Power BI dataflows:
This post started as a response to this question from Mark, who was commenting on last week’s data lineage post:
How would you decide how big or how small to make each artifact in the lineage, in terms of the amount of transformations taking place inside the artifact? In my case they would only be shared with 2-3 other users.
For instance I could go all out and have every step that would previously take place in a query editor result in a new link in the data lineage chain, but that would probably be overkill.I agree that “one step per dataflow” would be overkill, but beyond that the answer is largely “it depends.”
Read on to see on which factors it depends.