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.

     

ABC11's avatar
ABC11
Resolver I
4 years ago

Hi All,

I am new to power BI. When I connect to Oracle data source.Begining I was able see Advanced Option where I can write SQL query (like Select * from..... ). but now I am not able to see Advanced option diglog box. please, help me how can I see that box again where I can write my SQL query

Thanks,

ABC11