Reading BAI2 File types

Question

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.&nbsp;

greg_deckler · Answer

Perhaps convert it to a CSV file?https://www.treasurysoftware.com/utilities/BAI-2-Excel.aspx?msclkid=454e6f6d97c61c70fc1b31cd2f2c553f&amp;utm_source=bing&amp;utm_medium=cpc&amp;utm_campaign=Sub-%20General%20Terms%20TQE&amp;utm_term=%2BBAI%20%2BFile&amp;utm_content=BAI%20File

anonymous · Answer

alecpfeffer&nbsp;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&nbsp;Paul Zheng _ Community Support TeamIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Reading BAI2 File types

2 Replies

Related content

Type Mismatch

Parquet files reading into spark data frame is throwing data type error

Power BI read aloud

Error reading parquet files: Illegal Parquet type: INT64 (TIME(NANOS,true))

Transform columns / type