PowerBI and IRIS generating "The column '...' of the table wasn't found."
I have 3 simple tables: Encounter, Patient and Immunizations. Encounter makes a reference to Patient, and Patient contains a list of Immunization objects.
I've tried using PowerBI to access IRIS (using ODBC connector, not InterSystems BI connector), PowerBI reports the error:
Expression.Error: The column 'Patient' of the table wasn't found. Details: Patient
it does this for two of the three tables I need only (Patient and Encounter), but not for Immunization IRIS table..
Anyone know why and how to fix ?
Thanks - Steve