Clearing a PowerBI Dataset

Hi SimplyABA ,

To clear out old data from your Power BI dataset and ensure only the desired date range appears, follow these steps:

1. Remove 2023 Data in Query Editor:

   • Go to Power Query Editor.
   • Apply a filter on the date column to exclude data for 2023.
   • Make sure this filter is saved and applied before closing the editor.

2. Clear Data Cache:

   • After modifying your query, clear the dataset cache from the Power BI Service by going to Settings > Datasets > Clear Cache.

3. Ensure Data Model Refresh:

   • In Power BI Service, ensure the dataset is fully refreshed after clearing the cache and modifying the query.

4. Check for Stale Data:

   • Verify there is no stale data in the Data View of Power BI Desktop after the changes.

By following these steps, you should be able to remove the unwanted 2023 data and only show the new date range. If the issue persists, verify the query changes are being properly saved and applied during the refresh.

Please mark this as solution if it helps you. Appreciate Kudos.