Hi @iioannou,
Could you please explain a bit for the scenario you described as the example?
"If this record has a Reference e.g 123456 then the power bi table should use this and perform a query to bring the DATA."
How the Record reference is determined under the Power BI side? And which data should be brought out from Power BI side?
I don't think a field fill-in operation within PowerApps form would be able to act as a trigger to make Power BI load the data, or saying that this should be currently not supported, if I understand your meaning correctly.
Currentnly, PowerApps could only be available to read the filtered data from PowerApps custom Visual,
and within PowerApps, there is Power BI Tile control available, which makes it available to show Power BI Tiles within PowerApps.
Regards,
Michael