We have an on premise SQL Datawarehouse, and the management of both this environment and Power BI fall to the same group. I feel like data load from our on premise server to Power BI would be more efficient if we used dataflows however I have not seen this particular usecase featured. Would a load of tables in to dataflow mean a fact table is loaded once from On Prem and then reused accross my datamodels? It is quite sluggish building in to Workflow, then refreshing, then connecting to a desktop report and I am wondering if this is a wasted effort. Feedback is appreciated. Thanks
Solved! Go to Solution.
@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 been queried from other datasets, which opens even more possibilities.
Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!