Forum Discussion
Fetch Oracle HFM Data to PowerBI
Hi Team, We have a Data Source that is 'ORACLE HFM' . We Need to fetch Data From 'ORCALE HFM' to PowerBI . How can we do this Connectivity ?
Although this is an old post, just in case any one has the same question:
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
4. Build your Power BI Dashboard on the returned HFM dataset.
The same PowerBI query also works in an Excel power query.