Forum Discussion
Do I need a database?? Excel datasource...
If it ain't broke don't fix it.
There are many good Databases that have a free tier like Google BigQuery or SQL Server. The question is creating the pipeline to get your files into a table in the DB. If you are the only one that needs access to the folder, you may not need a database. The Power Bi model could be set to refresh at night. So even if it grows too large it won't comprimise proformance and you could always delete old files more easily from a folder than a database. See attached article.
Thanks rohit_singh , I use gmail but may have an option to use outlook as well and will keep that in mind.
I'm still looking for answer for questions 1 and 2.
If it ain't broke don't fix it.
There are many good Databases that have a free tier like Google BigQuery or SQL Server. The question is creating the pipeline to get your files into a table in the DB. If you are the only one that needs access to the folder, you may not need a database. The Power Bi model could be set to refresh at night. So even if it grows too large it won't comprimise proformance and you could always delete old files more easily from a folder than a database. See attached article.