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.