Make a model in Power BI with forms answers join to an Oracle table
I need to export the data of a form to Power BI. It seems easy doing a job with Power Automate that adds rows to a Power BI dataset, but this is not useful because for that I need to do a set of data in streaming that I can no longer join to the Oracle table I need.
I don't know if it would be possible to pass the data from the form to Sharepoint and from there read from Power BI and make the query to Oracle. How do you see better? Save the data in Sharepoint? Automate a job to pass me the data from Sharepoint to excel? Or do you know a better way to do it?