Skip to main content
Community site session details

Community site session details

Session Id : B7NhxBh6IbEJN41ZtSySSl
Power Apps - Microsoft Dataverse
Unanswered

Dataverse Virtual table throws errors when doing edits

Like (0) ShareShare
ReportReport
Posted on 25 Apr 2023 18:59:06 by Microsoft Employee

Hi, We are trying to create a Dataverse virtual table on top of Azure Synapse Analytics Dedicated SQL Pool. The table is created successfully. However, we are getting error when we try to update or insert record in Dataverse(via direct edit as well as edit in excel). It is working fine with Azure SQL DB. Please find attached Screenshot for Excel Error and dataverse error. Has anybody faced this issue?

Categories:
  • Data_Architect Profile Picture
    9 on 14 Mar 2024 at 09:31:19
    Re: Dataverse Virtual table throws errors when doing edits

    I have found more information. For a MS Fabric Lakehouse and associated Warehouse, the SQL Analytics Endpoint is Read-Only => sql-analytics-endpoint-read-only-mode

     

    But a Data Warehouse created in MS Fabric (independent of a Lakehouse) should allow full CRUD operations => compare-the-warehouse-and-the-sql-analytics-endpoint-of-the-lakehouse 

     

    I tried creating a separate Data Warehouse in MS Fabric, I could insert rows to the Data Warehouse from Azure Data Studio, but when I connected a Power Apps Virtual Table to the Data Warehouse table, I get the same error as @sribhashini.

     

    So it would appear there may be a problem with the Virtual Table connector to a MS Fabric Data Warehouse, as it should allow writing.

     

    Data_Architect_2-1710408559760.png

     

  • Shashank Bhide Profile Picture
    940 Moderator on 14 Mar 2024 at 04:03:19
    Re: Dataverse Virtual table throws errors when doing edits

    Sorry, I thought I posted the URL. Tho, haven't completely matched head to head with your scenario 

     

    https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features

  • Data_Architect Profile Picture
    9 on 14 Mar 2024 at 03:06:13
    Re: Dataverse Virtual table throws errors when doing edits

    Hi Shashankbhide, Thanks for the suggestion, can you provide the online link that describes serverless being unsupported?
    I am using MS Fabric DataLake with a SQL endpoint provided by Fabric to the Data Warehouse. Looking at the doco for Fabric, it would seem to suggest that Fabric is running serverless for SQL endpoint connections => Workload management - Microsoft Fabric | Microsoft Learn and this could be the issue as you suggest. This definitely gives me another avenue to investigate, Thanks.

  • Shashank Bhide Profile Picture
    940 Moderator on 13 Mar 2024 at 17:04:27
    Re: Dataverse Virtual table throws errors when doing edits

    Is it dedicated server pool or serverless mode, I see online that serverless doesn't support insert/update 

     

     

  • Data_Architect Profile Picture
    9 on 13 Mar 2024 at 10:02:30
    Re: Dataverse Virtual table throws errors when doing edits

    I get the same issue when trying to connect a Virtual Table to a MS Fabric Lakehouse table. I can connect and view the data, but the moment I try any kind of edit or insert the update dies with a BadGateway APIM issue.

     

    Data_Architect_0-1710324049174.png

     

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 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Featured topics

Loading started