1.  Prepare

Get Connected

• Parameters- Exercise

https://learn.microsoft.com/en-us/power-query/power-query-query-parameters

https://learn.microsoft.com/en-us/training/modules/get-data/3b-parameters

https://learn.microsoft.com/en-us/power-bi/connect-data/service-parameters

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

• XMLA – end point use by powebi to connect data in powerbi service. Same tool use in Excel, SSAS, VS etc.

https://learn.microsoft.com/en-us/fabric/enterprise/powerbi/service-premium-connect-tools

Evaluate Data

Shape the data

Aggregate

https://learn.microsoft.com/en-us/training/modules/optimize-model-power-bi/6-aggregations

https://learn.microsoft.com/en-us/fabric/enterprise/powerbi/aggregations-auto

Combine

Load

• Copy, Duplicate Vs Reference – Reference Vs Duplicate- Exercise

https://radacad.com/reference-vs-duplicate-in-power-bi-power-query-back-to-basics/

• Referencing
• https://learn.microsoft.com/en-us/power-bi/guidance/power-query-referenced-queries
• Copy or duplicate
• https://community.fabric.microsoft.com/t5/Desktop/Copy-Duplicate-amp-Reference-in-Query-Editor/m-p/340709

Errors

https://learn.microsoft.com/en-us/power-query/dealing-with-errors

Parameters

 

Performance