Hello everyone,
I wanted to use Power Apps in Power BI to write data back to the SQL database. For this, I created screens in the app. However, the control only shows "Display text" and not "edit text," so I can't input anything there.
Does anyone know what the issue might be? And how can I enable text input in the app?
Hi Vasanth,
Thank you very much for your answer.
Check the Control Types: I cannot change the Label control to a Text Input control in the properties pane, as the option in the control type does not exist. What should i do?
Update Power BI Settings for Power Apps Integration: I can't find the "Enable input" option anywhere. Could you please provide a screenshot?
Enable Editing Permissions in Power Apps: For this, I have a gateway connection to the SQL Database. Is that sufficient, or do I need additional permissions?
Thank you very much!
The issue you're experiencing is likely due to the default configuration of the controls in Power Apps when embedding the app in Power BI. Power BI embeds Power Apps primarily for viewing purposes, and input capabilities such as text boxes may be restricted depending on the configuration.
Here's how you can resolve this issue and enable text input in the app:
When you create the screens and add controls (like labels, text inputs, etc.) in Power Apps, ensure you're using Text Input controls instead of Label controls. Labels are only for display purposes and do not allow user input.
To change it:
When you embed Power Apps in Power BI, ensure that the Power Apps visual allows user interaction. If the interaction is not enabled correctly, it may prevent text input controls from working.
Steps to enable interaction:
Ensure that the app you're embedding has been published and is using the right environment with sufficient permissions for editing data.
Check the SQL connection in Power Apps:
To isolate the issue, test your Power App outside of Power BI by running it directly in Power Apps.
If after these checks the issue still persists, you may need to reconfigure the app permissions or explore additional settings related to Power BI and Power Apps integration.
----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!
Stay up to date on forum activity by subscribing.
mmbr1606
9
Super User 2025 Season 1
Julien1
7
ronaldwalcott
7