Share
ReportHi,
Trying to populate data in a denormalized table for reporting in Data Verse.
Being new to this topic, a quick search shows that I can trigger a Power Automate flow from a button press in a Power App and run an "Execute a SQL query".
More info: the data to be collected is small in nature, few thousand records only from 5-6 tables.
It looks like this :
delete * from reporting_table;
Insert into reporting_table (select col1, col2, col3 from source_table1 union source_table2 where ...)
Is this a good and workable approach? are there better ways to do it?
Many thanks
All responses (
Answers (
497
