cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Jacy Regular Visitor
Regular Visitor

OFX CONNECTION

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

1 REPLY 1
caaarlos Member
Member

Re: OFX CONNECTION

@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.

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 362 members 3,216 guests
Please welcome our newest community members: