Atomsvc to google sheet

[ydobwonk]

I have an Atomsvc file.

I can open in excel.

I can upload the excel file to Power Bi.

Questions...

1. Will the excel file and Power Bi file auto-update as the data changes from the website that the atomsvc is calling up? or do I need to "open" the excel file in order to update the file?

2. is there a way for Power Bi to "talk" to google sheets in order to have a live google sheet? I see google sheets talking to the Power Bi but not the other way.

Thank you

[Anonymous]

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