Forum Discussion
Differences between Advanced Option and Advanced Editor and their language
Hi Ha_Da
Advanced option in the dialog box shown is pulling the subset of data from the Database ( For Example, Instead of full table, you need only first 100 rows etc.). SQL statement is used in that case.
SELECT *
FROM XYZ
Advanced Editor is recording all the ETL steps in the "M" Language. This is the only language supported in the Query Editor. I would suggest you to buy "M for data monkey" if you are really serious to learn the language. There are quite a few good blogs as well which will guide you to learn M.
Google below blogs
1.Chris Webb's BI Blog
2. Ken Puls blog
3 Imke Fieldman Blog.
The Advanced Option is the underlying query your want to execute for retrieving dataset from your dataset. It can be T-SQL, MDX, DAX, etc, depending on your data source.
The Advanced Editor contains the applied steps onto dataset which are created in Power Query Language (refered to as M). For more detail information, please refer to links below:
Power Query (informally known as "M") Formula reference
Regards,
Thanks for your help.
