Hello Folks.
I have a SharePoint list that i need to update on a frequent basis from data coming in from SQL, which is displayed on a Power BI Report.
At the moment, i have a table of data on my Power BI Report and i export that table into Excel and i do a little formatting (e.g putting the table of data into a table, then manually uploading it to SharePoint).
Then i used Flow to grab the uploaded data to update the SharePoint list item. This process works fine. (i use the Rest API to update sharepoint, so it take under 3 mins to run)
However, its slightly time consuming exporting the data, creating a table and uploading. I played around with running Power Automate from within Power BI - but the problem i encountered was that Power Automate took too long to get every item inside of my table.
My flow has to have an Apply to each aswell.
When i use the first option, i use the List row present in a table, and the data is there within seconds.
When i Power Automate to get me all the data, it takes over 2 hours.
Is there a better way for me to automate my process without it taking 2 hours.