Forum Discussion
Auto update two excel files
Ive spent many hours searching the internet and trying various things but no success. Any help would be amazing. So the problem is fairly simple, it appears the soultion is more difficult I hav...
You want Power Automate for this, not Power BI. 🙂
It will be much easier for you if you use SharePoint lists to hold the data rows instead of Excel. You can create lists based on the Excel sheet to make this easier. The benefit of the SP list is that there is a Power Automate trigger for "when a new item is added to a SharePoint list", so that you can have actions performed when that happens. You need to have something reliable like this to trigger on or you'll make it really painful for yourself.
Once you have that automation set up, you can connect Power BI to the lists if you want to report on the resulting data--