PBIX dataset –> Connected to Power BI DataFlow (Cloud) –> Single DataFlow that append all SQL tables –> Multiple SQL Server database –> SQL querys that return unified result
Why Power BI Dataflow?
Because of the global inventory data size has exceeded pbix dataset size restriction (2.0 GB).
Data Reusability: other colleagues are able to use same data structure that have been already built.