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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
mbenay
New Member

Please help! When I update spreadsheet in excel it's not updating data in report

If anyone could help that would be fantastic- I had a free trial of Power BI Pro and now I'm worried that without it my files won't update... 

 

I have an excel file saved on my desktop that I have been using as the data source for a report. In the past, if I made changes to the file and saved and then refreshed the data in Power BI, the data in my report would automatically be updated. That's not happening now. Is the issue that it needs to be saved to OneDrive? Or is the issue that I don't have access to Pro anymore? Please help! Thank you in advance, 

1 REPLY 1
v-qiuyu-msft
Community Support
Community Support

Hi @mbenay,

 

When you refresh the dataset, is there any error throws out?

 

As the data source is local Excel file, the dataset need to be configured use gateway to refresh, please go to the dataset settings to see if used gateway is online.

 

q6.PNG

 

By the way, construct change like add a new column in the Excel file, it will not able to be displayed after refresh dataset.

 

Best Regards,
QiuyunYu

 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 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.