Connect to Epicor/Kinetic Odata Feed via Power BI - How To?

Kinetic ERP
1

Hello -

I have read through the Epicor’s latest REST services guide (v2_102700), scoured the internet, and reviewed posts here. Sadly, I’ve been unsuccessful in connecting Power BI or Excel to our Epicor Odata feed, nor have I been able to figure out definitively if it’s even possible. I’m wondering if there’s a how-to guide on how to go about setting up the connections in these applications?

I’ve gathered that our situation may be complicated by the fact that we’re running in Epicor’s multi-tenant SaaS environment. Does this fact prohibit from connecting via Power BI and/or Excel?

I’ve experimented with both OData Feed and Web connection types… No luck. The trouble seems to be with passing our API Key in a header parameter (x-api-key) and/or with our inability, being in a Saas environment, to thwart API security with web.config modifications.

I’m really hoping I’m missing something simple or obvious and that someone here will be willing to share some direction(s).

Thanks Very Much!

Alex

2

You can pass the api as a URL parameter too not just a header that should fix your issue

1 Like
3

I’ve done this before and I will tell you pulling odata via rest to powerbi is slow. Powerbi doesn’t cache the data when using odata.
If you can use the data gateway to sql or setup sql replication to an azure managed sql instance you will be much better performance.

1 Like
4

This worked… Thank You!