Power apps update a single record.

[shahhaider902]

I have no peior 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:

1. A list of names.
2. A connection to an Excel sheet with a single value that matches one of the names.
3. 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.

[Anonymous]

Hi @shahhaider902 

Thanks for the reply from lbendlin.

@shahhaider902 , I need to confirm with you: is there a problem with your Power Apps visual work or did PowerBI fail to re-run PQ after the Power Apps visual was updated?

If it is a problem with the Power Apps visual work, if possible, could you please provide the data structure of the data source, and the controls and formulas used in the App? And tell me how the App is configured?

If it is a problem after the update, could you please provide the data structure?

So that we can help you better. Please remove any sensitive data in advance.

Best Regards,
Yulia Xu

[shahhaider902]

Yes, the value which I will be passing into Excel is the primary key of first table in my dataflow : list of names.

[lbendlin]

the Power Apps visual will capture and update that name in the connected Excel sheet.

You can only write to tables (not to sheets) and you need to bring your own index column for that.  Does your dataflow have the index column value from the Excel table?