Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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
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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.