Share
Report
2I 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:
- A list of names.
- A connection to an Excel sheet with a single value that matches one of the names.
- A SQL source that returns data based on the name from the second table.
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:
- When I select a name in Power BI, the Power Apps visual will capture and update that name in the connected Excel sheet.
- After refreshing the dataflow, the third table will pull the relevant data from the SQL source using the updated name as a parameter from the second table.
Categories:
I have the same question (0)
All responses (
Answers (
