'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Data Not Updating in Power BI After Refresh
Question details
The user needs to resolve an issue where an Excel data source connected to Power BI Desktop or Service fails to update and display new records after triggering a refresh.
- Product
- Power BI / Microsoft Excel
- Device & OS
- not provided
- Scenario
- Refreshing a Power BI report connected to a local or online Excel data source to load the most recent data updates.
- Observed behavior
- The initial data load succeeds, but subsequent refreshes fail to reflect new data. This is typically caused by changed file paths, renamed worksheets, locked files, disabled load settings in Power Query, or incorrect gateway configurations online.
Ensure the source Excel file is closed and not currently being edited or locked by another user, as locked files will prevent Power BI from accessing the latest data.
Verify File Paths and Power Query Load Settings
Check if the Excel file was moved, renamed, or restricted by Power Query settings in Power BI Desktop.
Power BI maintains a strict connection to the exact file path, worksheet name, and table name of your Excel source. Any structural change will break the refresh process. Additionally, specific settings inside Power Query might exclude the data from being pushed to the report model.
In Power BI Desktop, navigate to the 'Home' tab, click 'Transform Data', and select 'Data source settings'. Verify that the file path pointing to your Excel file is completely accurate.
Open the Power Query Editor and review the 'Navigation' step in the 'Applied Steps' pane. Ensure that the specific worksheet or table names match the current state of your source Excel file.
In the Power Query Editor, right-click your specific query in the left pane. Ensure that both 'Enable load' and 'Include in report refresh' are checked with a tick mark.
Review your transformation steps for any applied filters (such as filtering out blank rows or specific dates) that might inadvertently exclude newly added data from loading.
Configure Data Gateways and Permissions for Power BI Service
Resolve online refresh failures by setting up the correct gateways and credentials for web-published reports.
Manage Your Spreadsheet Data Seamlessly with WPS Office
While troubleshooting complex Power BI connections, you can rely on WPS Office for creating, editing, and managing your source spreadsheets. It is a highly compatible, free alternative to Microsoft Office that handles large datasets with ease.
- 1. Download and Install: Visit the official WPS Office website to download the free suite and install it on your device.
- 2. Open Your Source Files: Launch WPS Spreadsheets and open your existing .xlsx or .csv data source files directly.
- 3. Edit and Save Seamlessly: Update your data, save the file, and seamlessly connect it to your BI tools for reporting.
Frequently Asked Questions
Why does my Power BI refresh work on Desktop but not online?
Power BI online (Service) operates in the cloud and cannot directly access local files stored on your computer's hard drive. To fix this, you must either move the source Excel file to a cloud platform like OneDrive/SharePoint, or configure an On-premises data gateway on your local network.
How can I share my Power BI report so other team members can update the Excel data?
Place both the source Excel file and the Power BI (.pbix) file in a shared network drive or cloud directory (like SharePoint). Ensure all necessary users have read and write permissions to that directory. Finally, update the data source path in Power BI to reflect this new shared network location instead of a local C: drive path.
How do I clear the cache in Power BI Desktop to force a fresh data pull?
Navigate to File > Options and settings > Options. Under the 'Global' section on the left, select 'Data Load'. Click on 'Clear Cache' under Data Cache Management Options to remove previously stored data and force a completely fresh fetch from the Excel source upon your next refresh.
