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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.