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
MerlinXL's avatar
MerlinXL
Frequent Visitor
3 years ago

MerlinXL  (merlinxl.com) has an HFM to PowerBI connector.  
1. Install the MerlinXL webservice on an HFM webserver. 
2. Create an HFM webform in HFM Workspace documents

3. Enter the query to the MerlinXL webservice in a PowerBI query specifying the HFM webform name to act as your dataset.  A webservice query template is provided, just change the url, application, and form name.
4. Build your Power BI Dashboard on the returned HFM dataset.

 

No complex SQL queries or understanding the HFM SQL schema, just a simple HFM dataform is all that is required. (although it does support more complex data queries if required)


The same MerlinXL PowerBI query also works in an Excel power query.