Fix a Deleted SharePoint List Item Still Appearing in Power BI and REST API Results
Question details
Determine why a deleted SharePoint list item still appears in Power BI and REST API results.

- Product
- SharePoint Online and Power BI
- Device & OS
- not provided
- Scenario
- A user deletes a SharePoint list item and expects it to disappear from reports and API responses.
- Observed behavior
- The deleted item remains visible in Power BI data and REST API results.
Record the affected item's ID, the SharePoint site and list names, and the REST API URL. Confirm that you have permission to view the list and refresh the Power BI semantic model.
Verify the SharePoint source and refresh Power BI
Use this approach to distinguish a stale Power BI result from a query against the wrong SharePoint source.
Open the SharePoint site, select Site contents, and open the affected list. Search for the item's ID and confirm that the item is no longer present.
Run a GET request against the correct site and list, using a URL such as https://your-site/_api/web/lists/getbytitle('ListName')/items(ID). Replace the site, list name, and ID with your values, and compare the result with the original REST query.
In Power BI Desktop, open the report and select Home > Refresh. If the report uses a semantic model in the Power BI service, open its workspace and select Refresh now for that model.
If the item remains, open Home > Transform data in Power BI Desktop and check the source and applied steps. Also check the REST URL for the correct site, list, filters, and item ID.
Create and delete a test item in another SharePoint list, then query that list and refresh its Power BI data. Compare the results to see whether the behavior is specific to the original list.

Check the SharePoint recycle bins
Use this to confirm the item's deletion status and permanently remove it if your organization requires that action.
Work with exported list data in WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar interface. Open compatible Microsoft Office files and move existing spreadsheet work into WPS easily. It does not fix SharePoint or Power BI refresh and API issues.

Frequently Asked Questions
Does an item need to be permanently deleted to disappear from a SharePoint list query?
Normally, no. An item in the Recycle Bin should not appear in a query of the active list. Verify the site, list, item ID, and REST URL if it still appears.
Why does Power BI still show an item that is gone from SharePoint?
An imported semantic model may still contain data from an earlier refresh. Select Home > Refresh in Power BI Desktop or Refresh now for the semantic model in the Power BI service.
Where can I find the SharePoint second-stage Recycle Bin?
Open the site's Recycle Bin and select Second-stage recycle bin. You may need site collection administrator permissions to access it.
How can I check whether the issue affects only one list?
Create and delete a test item in another SharePoint list, query that list through the REST API, and refresh its Power BI data. Compare the results with the original list.




