Reading BAI2 File types

[alecpfeffer]

Can Power Bi read BAI2 files (Bank Administration Institute files)? My bank is pushing me a daily BAI2 file for daily transactions and trying to load it into a report but not having luck with it. Any help would be greatly appreciated. 

[Anonymous]

@alecpfeffer 
Power bi does not support BAI2 files currently, you can covert it to excel first.

You can raise up an idea here helps to improve Power BI features: https://ideas.powerbi.com/forums/265200-power-bi-ideas

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

Perhaps convert it to a CSV file?
https://www.treasurysoftware.com/utilities/BAI-2-Excel.aspx?msclkid=454e6f6d97c61c70fc1b31cd2f2c553f...