Forum Discussion

Nese_FZ's avatar
Nese_FZ
Helper I
1 year ago
Solved

Data Base not update

When updating the database in pbi desktop that is connected to an excel table, it does not bring the updates even though it is processing normally.
  • johnbasha33's avatar
    1 year ago

    Nese_FZ 

    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 OptionsData LoadClear 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 !!