Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
MG1965
New Member

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.

1 ACCEPTED SOLUTION
v-binbinyu-msft
Community Support
Community Support

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.

View solution in original post

1 REPLY 1
v-binbinyu-msft
Community Support
Community Support

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Kudoed Authors