I'm using Power BI to embed a Power app via the power app visualization tool. My data in PBI connects to SQL Sever. In the Power app, I have the gallery screen to view the data, then an edit screen with the EditForm. The EditForm is also connected to SQL server because the user wants to view the data and edit it, sending it back to SQL. The problem I'm having is that no matter what permission changes I've made in SQL, I still cannot actually Edit the form. I've changed the DisplayMode to Edit.
In SQL, I right click on the table (I only need 1 table), then select Properties, then Permissions. I select my username and I keep checking "Grant" and "With Grant" but then they don't stay checked when I reopen.
I've refreshed my sql connection in power apps, but I still don't have the Edit Text available. I've changed the data card text to "Gallery.Selected.columnname" and also changed the display mode to edit.
Here is my app setup:
