OFX CONNECTION

[Jacy]

Hello, I need to read a bank file with .OFX extension.

I would like to know if there is a api or a native power bi connection for this type of file?

Thanks

[Anonymous]

@Jacy, I never worker with ofx file format, but did not find any working solution for Power BI to use ofx file. I have one idea, what about converting the ofx file to csv and then import it to Power BI? I found a node lib that can do that job for you. You can automate the conversion process and do not care about if Power BI has support for ofx files, since you will use a simple CSV file.

This is the library link. Hope it helps.