Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
We Need to Create PowerBI Reports using 'ORCALE HFM' Data Source.
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 .
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
86 | |
84 | |
68 | |
49 |
User | Count |
---|---|
139 | |
112 | |
104 | |
64 | |
60 |