Skip to main content

Notifications

Power Pages - Power Apps Portals
Unanswered

Virtual Table with lakehouse delta table have 00000000-0000-0000-0000-000000000000 row id

(0) ShareShare
ReportReport
Posted on by 2
Virtual Table with lakehouse delta table as the data source then @odata.id, @odata.editlink and cr341_<table>id all have 00000000-0000-0000-0000-000000000000
 
Hi all,
I am new to power platform. My virtual table has datasource sql connection from a lakehouse delta table. The table was able to load all the rows and columns from the delta table. Since it is a virtual table, I am not able to add additional key to the table, although I have set gid as the primary key for the virtual table, the virtual table still uses auto generated column <tablename> for the 32 digit GUID row id. In a flow, I was able to list the table rows, but got error from get row by ID since all the ids are the same.
 
There is a similar post suggested to add table permission, but I am not sure where that can be done. Your help is appreciated.
 
When I view the output of the list, it shows @odata.id, @odata.editlink and cr341_<table>id all have 00000000-0000-0000-0000-000000000000 as the value of the attribute or the partial value of the attribute.
 
 
Categories:

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard