Forum Discussion
New data added to Excel dataset (desktop) not pulling through to Power BI Desktop app after refresh.
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.
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?