Power Query allows you, whether you use Excel or Power BI, to connect to numerous data sources, retrieve, transform, and use “refined” data to create reports. On that occasion, each step in the transformation process is recorded and, when you refresh the link to the source, the steps are repeated in the given order and you get tables of identical structure. What is a purpose of Dataflows?