Share via

Unable to delete table from power pivot data model. Need help how to delete table ?

Anonymous
2020-02-13T09:49:03+00:00

Hi,

I am unable to delete a table from the power pivot data model. Need help on how to delete a table?

But I try to delete table getting the error

"This table was created in with power Query. To change this table .use power query instead" 

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-02-13T14:26:31+00:00

    Hi Lavdeep Kumar,

    Sorry for the inconvenience caused by this.

    Based on my research, this error happens because the edits are blocked and Power Query can change the queries in these connections. I would like to suggest you try this way to check the result:

    1. Open the Data tab in the Excel window.
    2. Click on Connections in Toolbar
    3. You should see connections which you want to delete. Choose them and try to delete.

    If the issue persists, we would like to connect more information about it:

    1. Does this issue happen to newly created worksheet?
    2. Can you please provide the full screenshot of Excel-> File-> Account-> Product Information for us?

    Regards,

    Ivy

    11 people found this answer helpful.
    0 comments
  2. Anonymous
    2020-02-15T14:25:29+00:00

    Hi Lavdeep Kumar,

    If there is any update at your end, please feel free to update.

    Thanks,

    Ivy

    0 comments