I'm looking to have reporting in Power BI. I need a connection or API connection to my trade data, I currently download statements and then format, create pivot tables and analyse the data, I have 3 accounts and like to do this a few times a day, so it's tedious.

Once I have a data connection and have sight of the data format, columns etc I'm confident I can use Power Bi to get the schematics I need but it's the connection I'm looking for.

Any feedback appreciated.