Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

deleting records

Hi all,   I am trying to understand if I can physically delete individual values (as opposed to tables or files) within a dataset, through Power BI.   My dataset consists of many uniform files th...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Anonymous 

    If you have errors in PQ you can right click on the column header and then choose Replace Errors and replace with null

    If you are wanting to replace specific values then a tediosu way to so it is right click the column header -> Replace Values and replace with null.

    Phil

    If I answered your question please mark my post as the solution.
    If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Not very clear. Is it a power bi dataset?

You have the option to delete rows in the power query.

Refer: https://community.powerbi.com/t5/Power-Query/How-to-dynamically-delete-Top-Rows-Before-a-specific-value-in-a/td-p/884790

https://community.powerbi.com/t5/Desktop/M-Power-Query-Removing-entire-rows-based-on-condition/td-p/367563

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=a1cfd615-a55f-4ef1-a60e-2b5d8b7c3d88&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    No, sorry it wasn't clear. 

    I don't want to delete whole rows, only specific values.

    Imagine you have a 10X10 table in excel and you want to delete the contents of cell D4, D8 and D10, and keep everything else.