QuestionQ143

Configure Microsoft Dataverse

A Microsoft Dataverse database has two custom tables named TableA and TableB, configured as follows:

  • A one-to-many relationship exists between TableA and TableB.
  • A lookup to TableA is displayed on a TableB form.
  • Both tables are components of an unmanaged solution.
  • Both tables are components in a Power BI report.

An error occurs when you try to delete TableA.

You need to delete the table.

What should you do?

  • A Remove TableA from the Power BI report.
  • B Remove the relationship between TableA and TableB.
  • C Remove TableA from the unmanaged solution.
  • D Remove the lookup field to TableA on the TableB form.
Explanation

A custom Dataverse table cannot be deleted while another component depends on it. The one-to-many relationship and its TableB lookup create that dependency. Removing the relationship removes the dependency; merely removing the lookup from a form leaves the lookup column and relationship intact. An unmanaged solution is only a container for unmanaged components, so removing a table from it does not delete the underlying dependency.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!