Updating a SharePoint list from within Power BI

[Vstar19]

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.