People new to Power BI often approach Power Query in the same way they approach data modeling, that is, by ignoring it. This is probably because unless you specifically ask to transform your data, it will be imported into Power BI Desktop relatively unchanged. People often don’t realize that whenever they load or refresh their data, it will pass through the Power Query funnel.
However, just like understanding the importance of a robust data model, Power Query is instrumental in shaping the data to achieve this goal. It would ...
