Good Morning from New Jersey,

It's been a while since I posted so I hope that this is informative enough to get the help I need.

I have a data model in Power Pivot that contains over 3 million rows of data. We had to move to this method due to row limitations in Excel. Data is appended to the data model frequently. There is a problem where a few of the cells (or fields?) are mislabeled and since the linked table doesn't contain that data anymore, then I cannot edit the data in the unlinked table. Is there a way to delete rows of data from a data model that isn't linked to a tab in Excel?

If there are any questions, I will do my best to answer them. I appreciate any advice I can get. If it's PowerQuery, or SQL, I might need advice on where to turn to learn it.

Many Thanks!