Forum Discussion
Manage a datawarehouse with dataflows
Hi, As indicated in the doc, we try to build a small dwh from scratch with dataflows. https://docs.microsoft.com/en-us/power-query/dataflows/best-practices-for-data-warehouse-using-dataflows ...
Hi Caitlyn,
Thks. I saw the thread before posting.
I know ETL processing for years, Oracle docs don't help me 😉
My problem is thechnical with dataflows. But i think the use case of building an historical table based on files with dataflows is difficult to achieve (impossible?).
I think that the concept of building a dwh with dataflows only works with a SQL Source.
I have the impression, that I will need to construct an historical table with an ETL on prem.
This limitation should be explained.