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.

     

BhaveshPatel's avatar
BhaveshPatel
Super User
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

Thank you very much. It do help me.