Autoamate the sharepoint export button without using power automate

Hi ganeshsanap,

Thanks for the response.

The meaning of "automating the export to excel button" is that I would like to use the function of the export button to export our sharepoint list itmes into csv file for power bi.

I have tried use power automate to add table and add rows, which is not best practice cause the export button function is good to go already.

I aslo tried power bi read from online sharepoint list which didn't work for unknow reason(internal server error). Some sources said the reason might be the list is over 5000 rows. (We have 6K itmes in list)