Forum Discussion
How to Update database for Power BI
Hi Anonymous
You can use a file from the mail as a data source.
Please refer to the linked guide :https://www.youtube.com/watch?v=Je3SnkYHnfc
Or to use power automate , the guide :
https://www.youtube.com/watch?v=C2zbv9ZfT-4If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hello Anonymous,
Thanks for your message.
One way you can accomplish this by using Power Automate to move your CSV data into a SharePoint list or SQL database.
This would mean creating a flow that triggers when an email is received, extracts the CSV, and appends the data to your chosen data source.
Then, in Power BI you can connect to the SharePoint list / SQL database and set the refresh automatically.
Hope this helps - Alternatively, lets connect and I can guide you through the process - Yes, its FREE 🙂 (https://topmate.io/sahirmaharaj/649292)