Fabric Virtual Table in Power App

[marierasmu123]

Hello everyone,

I am attempting to use the connection to Microsoft Fabric through a virtual table in Dataverse for my Power App. I have  create the table and integrate it into an app. However, I am not authorized to perform any actions with it.

I encounter this error when I try to edit a row or create a new one in my virtual table.

Has anyone succeeded in doing this?

[Lado_Kvara]

You have to create the table in Fabric Warehouse with Primary Key constraint. It'll work.

1. Create your table in Lakehouse.

2. Create empty table in Warehouse

CREATE TABLE [dbo].[table_name](
column1 varchar(10),
column2 varchar(10),
...
id BIGINT NOT NULL -- This will be the Primary Key and has to be NOT NULL
)

-- Add Primary Key Constraint
ALTER TABLE [dbo].[table_name] ADD CONSTRAINT pk_id PRIMARY KEY NONCLUSTERED (id) NOT ENFORCED

3. Load data

-- Insert data into table
INSERT INTO [dbo].[table_name]

4. Create Virtual Table in Power App

[pavanmanideep]

Hi,

Fabric is an all in one SAAS Based analytics platform, its not a standard database. From where are you fetching data to virtual table?

If I have answered your question, please mark your post as Solved.

If you like my response or got a direction forward to proceed, please give it a Thumbs Up. Appreciate your Kudos. You can accept more than one post as a solution.

Cheers,

PMDY

[pavanmanideep]

Hi,

Do you have Guid Column in your fabric datasource?

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up.

You can accept more than one post as a solution.

Cheers,

PMDY

[marierasmu123]

No, I don't have that, but even if I had, I don't see any option to create new rows through a power app and down to a fabric database, if a GUID needs to be generated from the app. Previously I used the identity type in SQL, but I can't find a similar function in fabric, so I'm also looking for a way to generate some kind of GUID in fabric.