Leveraging PowerShell to copy a Table in Power BI Desktop | Is this possible?

Hey folks - relitively new to PowerShell, but have been creating Power BI reports for a little while now. Here's my situation:

I have a colleague who does not have a VM, but created APIs via Python to bring in a bunch of data, and because he does not have a VM, he has to manually hit the refresh button on the PBIX file and republish to service once a day. This is all data regarding employee utilization.

Again, I am new to PowerShell, but would love to learn how to go about doing the following operation:

1) Navigate to SharePoint folder with PBIX File

2) Open that PBIX file

3) Copy 1 Table like so:

4) Open Excel, paste the table into new excel worksheet:

5) Save to OneDrive/SharePoint location

Is something like this possible? I know this is a very specific use case, but if anyone has any insights here, I'd appreciate any pointers.

Ps: My colleage had shared the dataset with me through Power BI service .. Am I jumping through unnecisary hoops here?