Passing auto-increment field to powerapp visual which is also a primary key

[iowakrz]

I have a table with an ID field set as auto-increment which is also the tables primary key.  My power bi matrix is based on the ID field as well as a number of other fields.  I've created the powerapp visual with all of the same field and the PA visual is interacting and refreshing Power BI but it will only interact with record #1 of the ID field.  It seems the BI visual is not passing the correct ID value to the PA visual.  The value is always 1.  The matrix in the BI visual is set to "don't summarize".  

Everything esle seems to be working fine.  I added a new form to the PA that was created and within PBI I can add a new record to the table and it will appear in the PBI matrix.  The only issue it trying to edit an existing record.

Has anyone run into this?  Thank you for any help.

[v-cherch-msft]

Hi @iowakrz 

I cannot fully understand it.Please show some screenshots about your issue.

Regards,

[iowakrz]

Try this to understand my problem.

1.  Create a SQL table with an ID field that is the identity as well as the primary key.

CREATE TABLE [dbo].[Leeco_Inventory_ComID](
[ComID] [int] IDENTITY (1,1) NOT Null,
[itemindex] [varchar](81) NULL,
[CDate] [datetimeoffset](7) NULL,
[UserID] [varchar](25) NULL,
[Comment] [varchar](255) NULL,
CONSTRAINT [PK__Leeco_In__C475FA25E8610962] PRIMARY KEY CLUSTERED
(
[ComID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

2. Bring that table with test data into a Power BI report and create a table showing the .

3. In the web version of Power BI use the powerapps visual and select all fields.  Creat a new powerapp.

4.  The powerapp which is created starts with a callery.  Change the default for the gailler to ComID which is the identity field and the primary key.  You will only receive values of 1.  It will not show the incremental values 1, 2, 3....

I attached a couple of pictures.