Power Platform Community Forum Thread Details

Trying to create a virtual table in PowerApps Dataverse using SQL server view. I'm able to connect to the SQL server and database and select a view. However, on the "Review and finish" step of creating the table, I received a generic "An unexpected error occurred" message and cannot complete the process.

I verified that the service account is being used for the connection.
The view exists and returns data when queried manually.
I've tried both with and without "Configure table and column names" checked.

Anyone know what the issue might be?

Categories:

Error handling

Hi @EC-24061734-0

It could be anywhere from the Key you are or are not using in your Database (side) of things, it could also be your Datagateway itself.

Setting aside your ability to create a Virtual table, are you able to create a simple canvas app that can call a Sproc, or query that would go against to that SQL Server as a simple test to verify its not your gateway or access (security) to the View.

Create virtual tables using virtual connectors in Microsoft Dataverse - Power Apps | Microsoft Learn

Validate your steps there (I am sure you probably did but do it again).

Does your gateway have proper access, do you have other things working against the Gateway just not this?

Do the simple validation step to make sure a very simple app can access the View, if it cannot then you know its not the Dataverse side at least.

Start there is my suggestion, you may in fact then narrow it down to which one it is above.