Forum Discussion
Shared datasets and refreshing
Hai
We have multiple user groups. Each user group (around 15) has its own focus, its own data. But connected to al those different area's is always the dimension 'payment agreements'.
I suppose we could have a shared dataset for each user group, consisting of a fact table with dimensions.
When the dimension 'payment agreements' is attached to every shared dataset (let's suppose there are 15 datasets), does this mean it has to be refreshed multiple times, so 15 times? Or is there a way so we only have to refresh that dimension of 17 million rows once and then every shared dataset will be updates automatically?
Regards
Ron
Regards
Ron
Hey Ron,
That is one purpose of dataflows, but another is to have independent refresh and to break mega-models up into components for efficency. There is a lot to love about dataflows, documentation link here.
Matt Roche provides the best info on his blog about dataflows, this is the most relevant to read up on: link here as well as here for the data refresh: link here
The refresh schedule of the data flow is independent of any downstream report that uses that data flow but the refresh of the report itself needs to be timed, synchronized with the data flow, so that it follows that of the data flow appropriately. Thus, when the dataset is refreshed it doesnt cause the dataflow tables to refresh over and over.
11 Replies
Anonymous - Currently it will need to refresh multiple times, once per dataset. Currently.
Hai Greg_Deckler , your answer fascinates me.
Cause you are saying "Currently"is there something you know that I don't know ? 🙂
Have you thought of making that dim a dataflow instead then incorporating that into your dataset? That way you only refresh your dataflow once instead of multiple times.
Hai gregpetrossian I have to read about that. Thougt dataflows were more for business-use to model their own data.
But what you mean is making a dataflow of that dimension and then that dataflow will be part of the datamodels / shared datasets in Power BI?Is there somewhere an example where I can read about it?
Regards
RonHey Ron,
That is one purpose of dataflows, but another is to have independent refresh and to break mega-models up into components for efficency. There is a lot to love about dataflows, documentation link here.
Matt Roche provides the best info on his blog about dataflows, this is the most relevant to read up on: link here as well as here for the data refresh: link here
The refresh schedule of the data flow is independent of any downstream report that uses that data flow but the refresh of the report itself needs to be timed, synchronized with the data flow, so that it follows that of the data flow appropriately. Thus, when the dataset is refreshed it doesnt cause the dataflow tables to refresh over and over.
