Appended data not reflecting in PowerBi

[Anonymous]

Recently I built a dashboard for one of my project 

Source file - Excel (where I append ~300 entries weekly across multiple sheets)

I have connection through this in the model and sheet level links using an index

However the appended data does not reflect in the powerbi model when I refresh or even transform in powerbi

I have used an index funtion in powerquery, can that be a reason why the appended data does not show up in powerbi? the index says 2160 but after appending my excel is a 2450 entries

Kindly help me☹️

[Anonymous]

Hi @Anonymous 

I did a test, but unfortunately it works well, I can't reproduce the issue you met, maybe you can try these steps:

Review the steps in your Power Query to ensure that the data transformation steps are correctly applied to the new data. Sometimes, steps like sorting or filtering can inadvertently exclude new entries.

Look for if there are any errors in the Power Query editor. Errors in any step can prevent the data from being loaded correctly.

The index function itself shouldn't prevent new data from being reflected, but there are a few things to check: Ensure that the index column is being correctly updated when new data is appended. Verify that the index column is not causing any errors during the refresh.

Make sure that all the queries involved in your data model are set to refresh. Sometimes, if the appended tables are not included in the refresh, the new data won't show up.

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[elitesmitpatel]

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