Forum Discussion
Automatic conditional writing to a new database
Hi,
A Power BI dashboard has been made out of an large automatic flow for all of the reporting. The wish is to automatically create a new list of projects that have not been submitted before the deadline. The Power BI alert tool can only notify of this, I think? Would there be an option to write to a new database such as a sharepoint list based on a certain criteria? Or what would the recommendation be?
Thank you for your help.
mmossel Power BI cannot do a write back, best would be to use Power Automate, export data from Power BI, and then import in SharePoint.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
2 Replies
mmossel Power BI cannot do a write back, best would be to use Power Automate, export data from Power BI, and then import in SharePoint.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡