I have no prior experience with Power apps. I am figuring out way to write back data from Power BI to extract data from source in parts because SQL query is complex & it is using recursion. In Power Query, my query always time outs.
My Power BI semantic model is connected to a dataflow as its data source. The dataflow contains three tables:
In Power BI, I want to implement a write-back feature to update the name value in the Excel sheet via Power Apps. The flow would work as follows: