Power BI Dataflow vs Data Warehouse Which one to choose

preview_player
Показать описание
Dataflow is the data transformation service in Power BI, and also some other Power Platform services. Data Warehouse is the cloud storage and also compute engine for data. I often get this question that: “Now that we have dataflow in Power BI, should we not use the Data warehouse? What are the differences? which is better? When to use what?” This article and video, explain answers to these questions.
Read my blog post here:

*******************

Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.

*******************

********
CONNECT with US!
********

********
Рекомендации по теме
Комментарии
Автор

Great video again, could you please make a video creating staging and etl dataflows as best practise as this is the most talked but missed tutorial in practical I see.one issue I see with dataflow is you end up adding many connections in gateway when your data comes from different databases.Thanks always :)

brijendraydv
Автор

Thank you.. 👍
Out of topic question, can aggregation be used in scenario like : hit cache for recent data and hit SQL dwh for historical data? I read about filtered Aggs article from Phil Seamark, but it doesn't actually do aggregation rather it's two separate fact tables which are summarised in measures.

Bharath_PBI
Автор

what does scalability mean? what is (or can't be ) scaled ? thanks for the car senario at the end -that is a good analogy for beginners..

mommafitbit
Автор

Thanks! Do you know the best way to sync live data from business central 365 to a dataflow data warehouse?

LandscapeInMotion
Автор

hi, can dataflow point the output of the data to another destination, like our DW rather than azure datalake ?

marounsader