Fetch Oracle HFM Data to PowerBI

[rakeshsaini]

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 ?

[MerlinXL]

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.

[rakeshsaini]

We Need to Create PowerBI Reports using 'ORCALE HFM' Data Source.

[rakeshsaini]

I see a Soluition , but in this Soluiton Every time Need to Create a Excel SpreadSheet from Data Source and than uplode to it PowerBI .

[v-caliao-msft]

Hi @rakeshsaini,

Gold to hear that your issue go solved. Please share the solution which will help others who have the simialr issue to find the solution esily. Besides, in your scenario, could modify the Excel Sheet, and refresh it by using Personal gateway.

Regards,

Charlie Liao