Appended data not reflecting in PowerBi

1. Recreate the Index After Appending:
Ensure that the Index function is applied after appending the data. To do this:

In Power Query, move the step where the index is created below the step where the tables are appended.
This way, Power Query will first append all the new data and then create or update the index accordingly.
2. Dynamic Index:
If the index is needed for unique identification or ordering, you can create a dynamic index that updates based on the latest row count.

In Power Query, create the index after appending the data by selecting the combined query and adding the index column at the end.
This will ensure that every row, including newly appended ones, receives a sequential index.
3. Ensure Data Refresh in Power BI:
Make sure to go to Home > Refresh in Power BI after the new data is appended to the Excel file.
You might also want to check that the Excel connection is set to refresh correctly by enabling Data Source Settings under Options > Current File > Data Load.
4. Check Query Dependencies:
In Power Query, check if the query containing the appended data is properly linked to the final query with the index column. You can view the Query Dependencies by right-clicking on the query and selecting View Dependencies.

If this helps please Accept it as Solution