Power Query Connect to Essbase Server

Question

Is there a way to connect to an Oracle Essbase Server using Power Query for Excel to extract data?

Answer 1

From here:

• In the POWER QUERY ribbon tab, click From Database > From Oracle
  Database.

• In the Oracle Database dialog box, in Server Name specify the Oracle Server to connect to. If a SID is required, this can be specified in the form of “ServerName/SID”.

• If you want to import data using native database query, specify your query in the SQL Statement box.

• Click OK.
• If the Oracle server requires database user credentials:
  • In the Access a Database dialog box, enter your username and password.
  • Click Save.