Appended data not reflecting in PowerBi

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.