Oracle Fusion HCM direct connection to PowerBI

[prasanthdbsae]

Hi Friends,

Can I connect Oracle fusion HCM Cloud to PowerBI directly using HCM REST APIs? Are there any limitations and security issues?

Your timely help is highly appreciated.

[AnalyticsFreak]

Hi @prasanthdbsae ,

BI Connector, a Power BI Certified connector, connects Power BI to Oracle HCM Cloud, and supports connectivity in both Import and Direct Query modes.

Here's a quick video to show a glimpse of what it does:

The connector works seamlessly with both Power BI Desktop and Service/Report Server clients via the Gateway, and supports Scheduled Refresh for Imports.

You can your visualize your HCM Subject Areas and Reports in minutes, without writing a single line of SQL Code! Blend your HCM data with other data sources, and automate the connection in Power BI Service also, not in days or hours, but in minutes!

Sign up now for early access!

[v-deddai1-msft · Accepted solution]

Hi @prasanthdbsae ,

I'm afraid that it don't support direct query  to Oracle Fusion HCM Cloud now. Please refer to https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources for the supported data source for Direct query

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[v-deddai1-msft]

Hi @prasanthdbsae ，

Yes, you can. Please refer to https://docs.oracle.com/en/cloud/saas/human-resources/20b/farws/index.html for details.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[prasanthdbsae]

Thank you for your suggested solution. If I use REST APIs I need to load the entire data model into PowerBI. Is there an option to have a direct live connection to Oracle Fusion HCM Cloud?

Thanks for your help.