Power Query for Excel - Need Help with Oracle SQL Syntax


  • Hello everyone,

    I am new to Power Query and am not able to figure this out.  I am trying to pull in data into my Excel spreadsheet using a specific Oracle SQL query.  While in query editor, how do I take the Oracle.Database function and add my SQL statement?  I already know what I want, I don't want it to download all the table names.  According to the help page, I should be able to do this but it does not provide a syntax example

    Also, I don't understand what "optional options as nullable record" means.

    Below is what function and arguments the help page notes.  How do I use this?

    Oracle.Database(server as text, optional options as nullable record) as table

    Any help is greatly appreciated.

    Thank you,


    Friday, October 25, 2013 2:50 AM


All replies