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.

  • 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 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 !!

2 Replies

  • 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 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-aatheeque's avatar
      v-aatheeque
      Community 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!