Reconciliation report- Get data from API based payment gateways like Bambora and chase E-xact

[Anonymous]

I am working on Reconciliation report in Power BI and need to get data from Payment gateway, to which I have only login details only available for access. What should be the best possible ways to get data from API based payment gateways like Bambora and chase E-xact??

[v-lili6-msft]

HI, @Anonymous 

It should have the same logic as others. 

Please refer to these documents:

https://docs.microsoft.com/en-us/rest/api/power-bi/

https://dev.applicationinsights.io/documentation/Using-the-API/Power-BI

Best Regards,

Lin