Hi there!
I am having some issues when connecting a powerapps to an excel workbook.
Here's the problem:
In my excel I have 2 sheets, the first sheet is called parameters and the second, values. In the first sheet I have some parameters which affect directly to my values in the second sheet, like these: value1 = parameter1 * 0.05
Then, I upload these parameters into a powerapps so I can change the parameters values directly into the PowerApps. After that, I want to plot the values in a Power Bi graph.
The problem starts here: Despite in the workbook the parameter is changed, the values in the second sheet are not unless I open the Excel workbook, so I cannot visualize the values in Power Bi directly without saving manually the Excel Workbook.
I understand that the calculations are done once I have opened the Excel, however I need them to be automatically updated, so I can visualize them in Power Bi without needing to open the Excel.
