How to connect Power BI with Oracle Fusion HCM custom BI Publisher reports?

[Elara_Feri2335]

Hi everyone,

We are trying to connect Power BI with Oracle Fusion HCM custom reports (BI Publisher reports).

We already have a custom report in BI Publisher that returns the correct data, but we are unsure how to connect it to Power BI for visualization and analysis.

Can someone advise on how to connect Power BI to a BI Publisher report from Oracle Fusion HCM?

Specifically:

1.How can the report be exposed so Power BI can access it?

2.How should the connection be configured in Power BI?

3.Are there any authentication or setup considerations we need to know?

Any advice or examples would be greatly appreciated.

Thank you.

[V-yubandi-msft]

Hi @Elara_Feri2335 ,
Could you let us know if your issue has been resolved or if you are still experiencing difficulties? Your feedback is valuable to the community and can help others facing similar problems.

[V-yubandi-msft]

Hi @Elara_Feri2335 ,

May I know if your issue is resolved, or if you need any further clarification?
Please review the response shared by @rajendraongole1 , and if you need any additional details, feel free to let us know.

Thank you for your valuable update @rajendraongole1 .

[rajendraongole1]

Hi @Elara_Feri2335  - Can you please check the below links:

https://support.biconnector.com/support/solutions/articles/8000121515-connect-power-bi-desktop-to-or...

How to Connect the Power BI Service to Oracle HCM Cloud: Complete Guide

coming to the question

You can specify parameters, output format (CSV/JSON/XML), and authentication headers.Power BI can call this endpoint using Power Query (Web.Contents)

try to connect power bi:

• Get Data → Web → URL, or

• Get Data → Folder (SFTP), or

• Get Data → Azure / OCI Storage

Hope these details helps.