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

The FabCon + SQLCon recap series starts April 14th at 8am Pacific. If you’re tracking where AI is going inside Fabric, this first session is a can't miss. Register now

Reply
Anonymous
Not applicable

How to update Excel data sources without uploading a new one

Am still a novice in PowerBi and currently evaluating it for a new company I work for. I have used it in a previous company and trying to recreate the same visualizations I did in my old job but running into one simple yet can't seem to figure it out issue. In the last company I used csv dumps from different SaaS vendors to update one file that sat in One Drive. That master xlsx file was connected to Power Bi so all I had to do each month is update the file and wait for the refresh to happen and Power Bi would then have the latest data from the set and update my reports. 

 

What's different here is that we do not have a license for One Drive but instead are a Google Shop. I have looked everywhere to see if there's an easy way to make the same connection using Google Drive but no cigar. So instead I created my master xlsx file and saved it to my desktop and created my first report. Now it's a new month and I have updated the xlxs file but can't seem to figure out a way to seemlessly replace that file in Power Bi and have it automatically update my reports using the updated file. The only option I see is to keep uploading the same xlxs, create a new datasource with the same name then recreating the report all over again which is time consuming and messy.


Please someone tell me there's a way out of my misery. 


Thanks

1 REPLY 1
Greg_Deckler
Community Champion
Community Champion

Hmm, I can tell you that if you use Desktop, you can run an update manually, re-publish and it overwrites what was there previously. Can't tell you much about Excel as I do everything in Desktop but kind of surprised that it wouldn't work similarly.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.

Top Solution Authors