I have a table in my Application layer which is based on a view from DSA.
The table in Applicaiton layer is a write-back from PBI App where certain columns have data from existing tables and others are empty so that Power App can write to these.
Whenever i make a change in my view, the table in Application becomes red.
I have tested the following senarios and both times i needed to Deploy and Execute to get rid of the red color and star at the end:
Made a minor change in VIEW:
Select column1 as A from table1
Select column2 as A from table1
I kept the alias but change the column.
Wrote a few comments
Now the issue is, i cant Deploy and Execute because then it wont keep the last changes written from PBI App. I need to just Execute or just save so that it wont be overritten/initialized.
Is there a way to only Execute when changes dont impact the table structure in Applicatons?
Best answer by rory.smithView original