Forum Discussion
Data Base not update
- 1 year ago
1. Check if you are updating the correct Excel file
This happens more often than you think —
Power BI connects to a specific file path. Maybe you updated a copy of the Excel file?👉 Go to Transform Data > Data Source Settings in Power BI.
👉 Check the exact path of the Excel file it's reading from.
👉 Confirm that it's the same file you're editing.
2. Check if Excel is OPEN while refreshing
If the Excel file is open in another program (especially Excel itself) when you refresh, sometimes Power BI can't read the "latest" saved changes properly.
✅ Solution:
-
Close the Excel file completely.
-
Save it first.
-
Then refresh Power BI.
3. Disable Caching in Power BI Desktop
Sometimes Power BI caches old preview data. To force it to pull fresh data:
-
Go to Options → Data Load → Clear Cache
-
Or while in Power BI:
-
Hit Transform Data > Refresh Preview inside Power Query Editor.
-
4. Check if you did "Close & Apply"
If you updated data in the Power Query Editor but didn't click "Close & Apply", changes won't show on your report visuals.
✅ After refreshing, make sure you press Close & Apply in Power Query.
5. Check for Filters/Transforms in Power Query
Sometimes, when you first connected the Excel file, you applied filters, removed rows/columns, or limited data.
-
Go to Transform Data and check if there are filters applied inside Power Query that are "hiding" the new rows.
✅ Example: if you set "Top 1000 rows" during development, it won't show more rows even if Excel now has more.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
-
1. Check if you are updating the correct Excel file
This happens more often than you think —
Power BI connects to a specific file path. Maybe you updated a copy of the Excel file?
👉 Go to Transform Data > Data Source Settings in Power BI.
👉 Check the exact path of the Excel file it's reading from.
👉 Confirm that it's the same file you're editing.
2. Check if Excel is OPEN while refreshing
If the Excel file is open in another program (especially Excel itself) when you refresh, sometimes Power BI can't read the "latest" saved changes properly.
✅ Solution:
-
Close the Excel file completely.
-
Save it first.
-
Then refresh Power BI.
3. Disable Caching in Power BI Desktop
Sometimes Power BI caches old preview data. To force it to pull fresh data:
-
Go to Options → Data Load → Clear Cache
-
Or while in Power BI:
-
Hit Transform Data > Refresh Preview inside Power Query Editor.
-
4. Check if you did "Close & Apply"
If you updated data in the Power Query Editor but didn't click "Close & Apply", changes won't show on your report visuals.
✅ After refreshing, make sure you press Close & Apply in Power Query.
5. Check for Filters/Transforms in Power Query
Sometimes, when you first connected the Excel file, you applied filters, removed rows/columns, or limited data.
-
Go to Transform Data and check if there are filters applied inside Power Query that are "hiding" the new rows.
✅ Example: if you set "Top 1000 rows" during development, it won't show more rows even if Excel now has more.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
- v-aatheeque1 year agoCommunity Support
Hi Nese_FZ
If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!