Power Platform Community Forum Thread Details

Hello,
I'm trying to write back to an Excel Sharepoint file through a Power BI Integration. I've confirmed the data connection works with basic information display in Power BI, but I can't seem to get the Edit Form to work.
It returns the last 'OrgCode' as an error type, but I can't seem to understand why. It doesn't auto-populate in the formula bar when I reach that section either. I have it in the Excel table as a data source as well as a duplicated table in Power BI.

My current formula is:
LookUp(InfractionsExceptions,'OrgCode' = First(PowerBIIntegration.Data).'OrgCode')

I've searched all around and this seems to be the established format for this lookup, but the final field is unrecognizable.

Any insight would be welcome! Thanks