New data added to Excel dataset (desktop) not pulling through to Power BI Desktop app after refresh.

[FMHD5]

I added new data to rows a couple of days ago. Normally, when new data is added, changes saved and the report refreshed in the PBI desktop app, all new data pulls through.

The data was copied/pasted but I've checked the format to ensure that it mirrors the other columns and rows but it is still not appearing on my table. Initially, it was a worksheet but I converted it to a table to see if that would help...no joy. I'm only using one data set so relationships aren't an issue.

Any suggestions?

[Anonymous]

Hi @FMHD5 ,

May I ask what is your connection to excel? Perhaps you are connecting to a data source via parameter and some setting in parameter is preventing new data from coming in?
If there is no problem with this item, please check the existing query steps in Power Query, perhaps some of these steps are causing the new data to disappear, because Power Query runs all the steps again each time the query is performed.

Also make sure that "Enable load" and "Include in report refresh" are turned on in your query options.

Or do you have an RLS set up in your report that is causing you to be invisible to this part of the data?
If none of the above reasons are correct, please create a new pbix file and reconnect to Excel after the update to see if all the data is imported into Desktop, if the problem still exists after creating a new one, then it may be a problem with some settings in Excel.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FMHD5]

Thank you . I've all of the above but no luck. From analysing the dataset using conditional formatting, it seems that Excel, anyway, considers the missing items to be duplicates even though they are not. They are similar but not identical. When I created a card to verify the numbers, the count is correct but the distinct count is not... is there a setting on the table that I can use to show those that are considered duplicates? I tried creating an index in the dataset to set them apart (numbering) but it didn't change anything...thoughts?

[Idrissshatila]

Hello @FMHD5 ,

check if the data is being pulled into power query, if yes then check if there's any step in power query that is preventing the new data to show.

if there's nothing preventing the data, then check if there's any filter in the report that is preventing the data to show.

[FMHD5]

Thank you. The data hasn't pulled through to query and there are no filters at the moment...I'm at a loss!