Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Write data to a SQL table

I'm need to write some datas to a SQL table but i have the error "Structure: the column was generated by the server and can not be specified."


And when i tried to delete some line of this table appear the error : "the data source is read-only so it is not possible to write the remove function on it".



Super User
Super User

Re: Write data to a SQL table



As suggested in your previous post, 


The error that you are getting arises when there is no primary key in the SQL table. Please make sure that you have at least one primary key in the SQL table. If the issue still persists, after creating primary key, please let me know.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Community Support Team
Community Support Team

Re: Write data to a SQL table

Hi @Fabio_Hiroshi 


Do you test with @yashag2255 's suggestion?

Is the issue already exists now?


Best Regards.



Re: Write data to a SQL table

Hi @Fabio_Hiroshi are you still experiencing this issue? Was the above reply helpful? 



Helpful resources


Watch Sessions On Demand!

Continue your learning in our online communities.


Follow PowerApps on Twitter

Stay Up-to-Date by following PowerApps on Twitter

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Power Platform World Tour

Coming to a city near you


PowerApps Community User Group Member Badge

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


Join PowerApps User Group!!

Connect, share, and learn with your peers year-round


Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

Users Online
Currently online: 164 members 4,631 guests
Please welcome our newest community members: