Forum Discussion

Ha_Da's avatar
Ha_Da
Frequent Visitor
9 years ago
Solved

Differences between Advanced Option and Advanced Editor and their language

Hi All,   I am totally new for Power BI and investigate it for a month. Now I need to load data from Oracle database using advanced option. Which language should I use in Advanced Opt...
Need Help
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    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.

     

Ha_Da's avatar
Ha_Da
Frequent Visitor
9 years ago

Fundamentally the difference between advanced options and advanced query or query edit mode is where the execution of operations is being performed.

 

Advanced Options allows you to write custom SQL queries that are executed against the data source.

Advanced query allows you to write custom M query code against data that is already imported into the workbook.

 

Advanced options = Executed against original data source on data extract process

Advanced Query = Executed locally in workbook against imported data