Hi @emma313823 - I think you are right that a DB would be helpful for your needs. You should be able to connect PowerBI to the database (couple of posts here and here for example).
Good luck, happy building, and the forums are here for you if you run into any challenges!