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.
Hi b2wise ,
I can answer #3 above. In case you use outlook as your email client, you can add a folder as a source for your report and fetch attachments directly from your email. Please refer to this blog below :
https://radacad.com/import-email-attachments-directly-into-a-power-bi-report-using-power-query
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 😊
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.
