Forum Discussion

rakeshsaini's avatar
rakeshsaini
Icon for Helper II rankHelper II
9 years ago

ORACLE HFM to PowerBI Integration

Hello PowerBI Team ,   We Need to Create a PowerBI Reports using 'ORACLE HFM' Data Source. So for this We Need to get Data from 'ORACLE HFM' Data Source and Used this Data in to PowerBI Desktop.  ...
General Comment
Need Help
Show and Tell
Tips and Tricks
SandeepKomminen's avatar
SandeepKomminen
Regular Visitor
9 years ago

In order to connect to an Oracle ORACLE HFM database with Power BI Desktop, the correct Oracle client software must be installed on the computer running Power BI Desktop. Which Oracle client software you use depends on which version of Power BI Desktop you have installed - the 32-bit version or the 64-bit version.

Supported versions: Oracle 9 and later, Oracle client software 8.1.7 and later. To determine which version of Power BI Desktop is installed, select File > About then check the Version: line. 

Once the matching Oracle client driver is installed, you can connect to an Oracle database. Take the following steps to make the connection.

  1. From the Get Data window, select Database > Oracle Database

  2. In the Oracle Database dialog that appears, provide the name of the server, and select Connect. If a SID is required, you can specify that using the format: ServerName/SID.
  3. If you want to import data using a native database query, you can put your query in the SQL Statement box, available by expanding the Advanced options section of the Oracle Database dialog.

  4. Once your Oracle database information is entered into the Oracle Database dialog (including any optional information such as a SID or a native database query), select OK to connect.

  5. If the Oracle database requires database user credentials, input those credentials in the dialog when prompted. For More Information Visit : (Tekslate) https://goo.gl/vVec5j