Atomsvc to google sheet

Hi ydobwonk ,

According to your description, if you need to do a refresh dataization, for excel, you need to manually open the Excel file and refresh it to extract the latest data from the source.
Refresh an external data connection in Excel - Microsoft Support
For power BI Desktop, you can perform a file refresh.For uploading to power bi service, you need to configure timed refresh. The method of refreshing depends on what software you are using.
Data refresh in Power BI - Power BI | Microsoft Learn
Second question, power bi can now fetch data directly from google sheets by fetching the data.
Power Query Google Sheets connector - Power Query | Microsoft Learn
If you want to do it the other way around, there is no direct way to do it, but you can export the data to a csv file and upload it to the google sheet.
Export data from a Power BI visualization - Power BI | Microsoft Learn

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly