Forum Discussion
Does Dataflow reduce the need to load data on source databases
BrookBracewell2 wrote:Would a load of tables in to dataflow mean a fact table is loaded once from On Prem and then reused accross my datamodels?
BrookBracewell2 wrote:Would a load of tables in to dataflow mean a fact table is loaded once from On Prem and then reused accross my datamodels?
Yes, the re-use of source data across datasets is one of the primary use cases for dataflows.
BrookBracewell2 wrote:Would a load of tables in to dataflow mean a fact table is loaded once from On Prem and then reused accross my datamodels?
BrookBracewell2 wrote:Would a load of tables in to dataflow mean a fact table is loaded once from On Prem and then reused accross my datamodels?
Yes, the re-use of source data across datasets is one of the primary use cases for dataflows.
otravers
I hit a nother stumbling block, which is the requirement to have a shared model accross workspaces. Any thoughts on that?Yes, you can now share datasets and even promote them within an organization:
Share a dataset - Power BI | Microsoft Docs
Power BI datasets can now also be queried from other datasets, which opens even more possibilities.
Thanks- I am still not sold on the concept.
You load data to DataFlows, but still need to do a subsequent refresh of the datamodel. It might be quicker in Service than pulling from on Prem SQL database- but it still feels a way off what I want it to be - but I am quite demanding! 🙂
