Skip to main content
Community site session details

Community site session details

Session Id : fe0Gr5OoQuJ2tIyGz8u2Ik
Power Apps - Microsoft Dataverse
Unanswered

How to remove a virtual table

Like (0) ShareShare
ReportReport
Posted on 27 Sep 2022 09:58:58 by 82

Some time ago I gave it a try to add a virtual table to my dataverse. I followed the steps from https://docs.microsoft.com/en-us/power-apps/developer/data-platform/virtual-entities/create-virtual-tables-using-connectors?tabs=sql

 

I added the connector, created a connection and tried creating a virtual table.

 

But now I cannot delete the virtual entity data source because of dependencies (Advanced Settings > Administration > Virtual Entity Data Sources).

 

When I try to delete the virtual table I again get the message that deletion is impossible because of dependencies. This time reverring to Microsoft.Xrm.DataProvider.Connector.Plugins.ConnectorGenerateVEPlugin.

 

How can I remove a virtual table?

 

  • Nhelgren Profile Picture
    on 03 Oct 2022 at 15:58:41
    Re: How to remove a virtual table

    Hi @ellenheijmans2, I found the issue. Go into Solutions and then search for the first item on your list (note, it may be in your default solution). That is a plugin that is working with the Entity Catalog and must be deleted before the Entity Catalog table can be deleted. 

  • ellenheijmans2 Profile Picture
    2 on 03 Oct 2022 at 09:46:27
    Re: How to remove a virtual table

    I see a Virtual Connector Provider in de Default Solution, but I cannot delete it because of, gues what, dependencies.

     

    I think the problem is that I first removed the connection, before removing the table. Somehow the table still refers to a connection that is long gone. So i can't remove the table because it still thinks it's connected, and I can't remove the connection because it's already deleted.

     

    Maybe if I had done it the other way around, I wouldn't have had this problem.

  • Nhelgren Profile Picture
    on 29 Sep 2022 at 15:17:07
    Re: How to remove a virtual table

    Some things I would check: 

    • Make sure that those dependencies are not present in a named solution as well as the default solution. It's possible you may have placed them in the default solution and had not noticed.
    • Make sure you have removed the connection references
    • In case there is an issue with the dependency checker error messages make sure you have no custom forms, views, or apps somewhere that are consuming the VT
  • Ellen Heijmans Profile Picture
    82 on 29 Sep 2022 at 14:19:17
    Re: How to remove a virtual table

    Doesn't matter where I check it, it says the same. There are dependencies. But these connections I have are removed before. Zucht.png

  • Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on 29 Sep 2022 at 11:43:20
    Re: How to remove a virtual table

    Including @NHelgren  to see if he has any ideas...

  • Ram Prakash Profile Picture
    5,299 Super User 2025 Season 2 on 29 Sep 2022 at 04:27:12
    Re: How to remove a virtual table

    Hi @EllenHeijmans 

     

    Hope you are doing good.

     

    Try below steps on how to check Virtual Tables.

     

    1. Navigate to https://make.powerapps.com

    2. Click Gear Icon at the Top

    3. Select Advance Settings

    4. It will open a Pop Up now Select Settings --> Select Customization

    5. Then Select Customize the System

    6. It will Open a Pop Up --> Expand Entities --> Now You need to Click on ENTITY Name(Consider if the Table is Account then you need to select Account) 

    7. Then Check the Virtual Entities there.

     

    Please mark as Answer if it is helpful and provide Kudos


    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
    Follow me on Twitter : @rampprakashd
    Blog : https://microsoftcrmtechie.blogspot.com

     

  • Ellen Heijmans Profile Picture
    82 on 28 Sep 2022 at 07:02:37
    Re: How to remove a virtual table

    That's wat I did. Than it says that the dependency is Microsoft.Xrm.DataProvider.Connector.Plugins.ConnectorGenerateVEPlugin. No idea where to find it.

     

    I first removed all connections in make.powerapps.com optie Dataverse, Connections that used the virtual connector.

     

    Then I went to Advanced Settings > Administration > Virtual Entity Data Sources and tried to remove it. But I can't because of dependencies to the table I'm trying to remove, it says.

     

    It's what we Dutch call an chicken and egg problem.

     

     

  • AhmedSalih Profile Picture
    6,678 Moderator on 27 Sep 2022 at 15:34:03
    Re: How to remove a virtual table

    Hello, @EllenHeijmans, you will have to remove all those dependencies firs. From with in the solution where you have this virtual table, select the table > click advanced > show dependencies.

     

    Track down those dependencies and remove them for you to be able to delete the table.

     

     

     

    If my reply helped you, please give a đź‘Ť , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


    I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


    Visit my Blog: www.powerplatformplace.com


     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Featured topics

Loading complete