Delete data from an existing report

MG1965 — Tue, 23 Jan 2024 15:45:50 GMT

I have various Power BI reports that I typically feed with data from Excel. I add new data monthly. One of my data sources doesn’t exist anymore, hence I now have a break in my data chain, therefore my year-to-date, month-to-month etc. results aren’t correct anymore.

As I can’t solve the issue of the missing data my idea was to start the reporting from the beginning starting with December 2023. My question is, how do I delete all the old data from the reports so that there is only the data starting December 2023?

The repots where created by an IT specialist who doesn’t work for the company anymore.

Re: Delete data from an existing report

Anonymous — Wed, 24 Jan 2024 02:30:30 GMT

Hi MG1965 ,

Please try below steps:

1. Download the report file in Power BI Service Portal/ PBIRS Web Portal

2. Open the .pbix file in Power BI Desktop

3. Open the Power Query pane in Power BI Desktop

4. Delete the old data in Power Query, close and apply

5. Save the .pbix file and publish it to the Power BI Service Portal/ PBIRS Web Portal

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Re: Delete data from an existing report in Report Server

Delete data from an existing report

Re: Delete data from an existing report