HI, I have built a power app that integrates with Power BI to create and edit the records in Azure SQL. Although my code is working seamlessly, I found that certain records that fall in a certain category are not getting updated and I am getting below error. My code is mentioned below. Could anyone please help me how to fix this?
P.S.:When I checked in the app checker, it is showing under Run Time error.
Patch(
NIT_Accounts_Final,
ForAll(
[@PowerBIIntegration].Data As aPBI,
{
Approved: Dropdown1.Selected.Value,
Description: aPBI.Description,
BDC_Code:aPBI.BDC_Code,
Account_Name: aPBI.Account_Name,
Unique_Key: aPBI.Unique_Key,
UPC_Code: aPBI.UPC_Code,
Edited_Time: Now()
}
)
);
Reset(Dropdown1);
Set(Revvar,false);
PowerBIIntegration.Refresh()

Report
All responses (
Answers (