Forum Discussion
Shared datasets and refreshing
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.
Hai Greg_Deckler , your answer fascinates me.
Cause you are saying "Currently"
is there something you know that I don't know ? 🙂
Hai Greg_Deckler
I am fairly new to Power BI but read about Composite models. Dual mode, whereby depending on the question Direct Query or Import mode is used.
But I don't fully understand how this helps me in the fact that my main dimensions only have to be refreshed once.
Can you explain with a little example?Regards
Ron
Anonymous - In theory, and I don't speak for the product team or Microsoft. But, in theory you would be able to build a composite data model that includes a live connection to a Power BI dataset. So, in theory you could have the data for your dimension that is shared across datasets stored once as it's own dataset that you then connect to live from your other datasets. Make sense?
Makes sense Greg_Deckler