Power BI Integration - Not Recognizing Column Name

(0) Share

Report

Posted on by NKulesa

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

Categories:

Issue

Screenshot 2023-0...

All responses (1)

Answers (0)

GSharma145 2 on at

Like (0)

Report

Re: Power BI Integration - Not Recognizing Column Name

Hello Brother,

Did you get the answer to this???
How did you resolve it?