Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
ydobwonk
New Member

Atomsvc to google sheet

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

1 REPLY 1
Anonymous
Not applicable

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

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.