Power Query became available in * * Microsoft Excel 2010 * *
Power Query is available in * * Microsoft Excel 2010 * * and above. The details of each version are as follows:
---
# # # ✅ * * Excel 2010 / 2013 * *
* Power Query is available as an * * add-in * * that must be downloaded and installed separately from Microsoft.
* Supported in * * Excel Professional Plus * * and * * Excel Standalone * *
* Once installed, the "Power Query" tab will appear in the Ribbon.
# # # ✅ * * Excel 2016 and up * *
* Power Query is * * included in Excel automatically * *
* There is no name "Power Query" in the Ribbon, but the feature is in the tab * * "Data" > "Get & Transform Data" * *
* Easier to use and can connect multiple data sources such as Excel, CSV, SQL, Web API etc.
# # # ✅ * * Excel for Microsoft 365 / Excel 2019 / Excel 2021 * *
* Power Query has been improved to support more new features, e.g.
* Automatic Refresh Data
* Using Power Query with Dynamic Arrays
* Writing formulas in more flexible M code
---
# # # 🔒 Note
* * * Excel Online (Web version) * * * Currently * * Full Query editing is not supported * * (Partial Read)
* Some features may not work in Excel Home & Student or Excel versions without the full feature.
---
If you want to check if your Excel has Power Query:
1.Open Excel
2. Go to the tab * * "Data" * *
3.See the command group * * "Get & Transform Data" * * - If available, Power Query is available.
--------------------------
Power Query Workshop Course
https://analyst-development.net/Course/Details/powerquery





























































































