cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
usr_bi
Level: Power Up

Conexión a Sql Server local

Buen dia, ya tengo mi aplicación conectada a SQL server local y leo los datos, pero cuando hago el formulario de editar me registra un mensaje que no el usuario no tiene permisos para escribir en la base de datos, ya valide y tengo permisos, que puede ser??

 

 

1 REPLY 1
PowerApps Staff CarlosFigueira
PowerApps Staff

Re: Conexión a Sql Server local

Can you make sure that your SQL table has a primary key defined? This is an error that can be presented if you are trying to access a table without one (it's basically treated as a view).

For example, if I define my SQL table as

CREATE TABLE PowerAppsTest.ForumThread305460 (
	[Name] NVARCHAR(MAX),
	[Age] INT
)

INSERT INTO PowerAppsTest.ForumThread305460 ([Name], [Age])
VALUES ('John Doe', 33), ('Jane Roe', 32), ('Jim Poe', 30), ('Joan Coe', 31)

And try to use the table in PowerApps, I'll be able to read values from it, but not delete / update existing values - since there's no primary key, PowerApps can't follow the protocol to update values.

If you define one of the columns as a primary key (or add another one to be the key) then it should work.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,809)