Get Replicon Report data in to Power BI

[rush]

Hi All

I have a report that I created in Replicon and I am needing to import that data into Power BI.

Not sure if there is an API I can leverage.

Thanks in advance.

[sevenhills]

Will this be helpful?

https://www.replicon.com/help/using-microsoft-power-bi-to-analyze-your-replicon-data/#connecting-usi...

[rush]

@sevenhills Thank you but I am struggling with calling an API that has headers & a body along with a static bearer token. Is there a template one could use?

[sevenhills]

Mask all sensitive info for sharing in this public forum. And Can you share the screenshot / code?

[rush]

Please see the details below that I can call via Power Automate:

[rush]

@sevenhills , Thanks but unfortunately not.

That integration does not bring back any custom fields.

There is an API one can call that uses a bearer token but I cannot get it to work.

[Anonymous]

Hello Rush, 
Did you resolve the issue? Initially I had the same problem, but now the token allows me to access replication APIs.
In the same way. I want to connect to the APIs in the below link but i cannot use the token generated from the replicon service API document to access the APIs in the below link. do you have any idea?https://na9.replicon.com/PCLSandbox/services/help/all

[sevenhills]

It is tough without seeing the code and issue.

But, These links will give you an idea to connect to an API, with tokens

https://gist.github.com/jrosell/f161e77753b307c21570eca634f60de8

https://www.c-sharpcorner.com/article/call-rest-apis-from-power-bi-power-query/

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageK...

Hope this helps!