Forum Discussion
Delete data from an existing report
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.
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.
1 Reply
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.