cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kinga99
Helper II
Helper II

Refresh doesn't remove rows

I ofter change my data set when I experiement with DAX, but then something strange happened.

My excel table had 16 rows of data.  I removed 10 rows from my spreadsheet and left only 6. I also changed the numbers in those 6 rows. When I clicked "Refresh", all of the numbers were updated, but the 10 rows did not disappear!

 

Now, I don't want to remove those rows in Power Query, because that operation will be performed every time new table loads. I want to make sure Power BI loads only those rows that I have saved in my current file.

 

I did make sure to save the excel sheet, and the names are all the same too.

1 ACCEPTED SOLUTION

Thank you all for responding. This was actually a very silly mistake. The 10 rows that kept showing up in my report were hidden in Excel - not deleted 😞

View solution in original post

4 REPLIES 4
v-frfei-msft
Community Support
Community Support

Hi @Kinga99 ,

 

Based on my test, I cannot reproduce your issue here using Power Bi desktop Version: 2.79.5768.721 64-bit (March 2020). Could you please tell me how did remove your rows. Please delete rows instead of making them being space to check again.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Thank you all for responding. This was actually a very silly mistake. The 10 rows that kept showing up in my report were hidden in Excel - not deleted 😞

View solution in original post

amitchandak
Super User
Super User

@Kinga99 , Where do see those rows. Do you see them empty? Because the values have changed after refresh means changes have taken place.

Seem like you deleted values. Not the rows. Select the rows in excel and delete. And then try.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
Greg_Deckler
Super User
Super User

That's extremely odd. Where is this Excel file located?

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!