Forum Discussion

4 Replies

  • rakeshsaini's avatar
    rakeshsaini
    Helper II
    9 years ago

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

     

     

     

     

    • rakeshsaini's avatar
      rakeshsaini
      Helper II
      9 years ago

      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's avatar
        v-caliao-msft
        Microsoft Employee
        9 years ago

        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

  • MerlinXL's avatar
    MerlinXL
    Frequent Visitor
    3 years ago

    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.