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 con

data write back to the SQL database using Power Apps

Hi,

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:

1. Check the Control Types

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.

If you're using a Label control, change it to a Text Input control.
- Text Input allows users to type in data.
- Label is for displaying read-only text.

To change it:

Select the control where you see "Display Text".
In the properties pane, change the control to Text Input.

2. Update Power BI Settings for Power Apps Integration

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:

Go to your Power BI report.
Select the Power Apps visual you’ve embedded.
In the Power Apps settings, make sure the "Enable input" option is checked, which will allow users to interact with the app embedded in Power BI.

3. Enable Editing Permissions in Power Apps

Ensure that the app you're embedding has been published and is using the right environment with sufficient permissions for editing data.

Ensure that the user who’s accessing the app through Power BI has appropriate permissions to write to the SQL database via Power Apps.
The SQL connection in the app should be configured to allow the user to edit and write back to the database.

Check the SQL connection in Power Apps:

Ensure that you are using the correct SQL Server connection in Power Apps and that it’s properly configured to allow write access to the database.
You might need to verify the credentials being used by the app, especially if it’s embedded in Power BI. The user may need to authenticate and have permissions to make changes in the database.

4. Test the Power App Independently

To isolate the issue, test your Power App outside of Power BI by running it directly in Power Apps.

If it works fine there, the problem is likely related to how the Power App is embedded or how Power BI is handling the app.
If it doesn’t work in Power Apps either, the issue is with the controls or permissions in Power Apps.

5. Update and Re-publish the Power App

After making any changes (e.g., switching from a Label to a Text Input control), make sure to re-publish the app in Power Apps so that the updates reflect in the Power BI report.
Refresh the Power BI report after making changes to ensure the app is loading with the updated functionality.

Summary Checklist:

Use Text Input controls, not Labels, for editable fields.
Check Power BI settings to ensure input is enabled in the Power Apps visual.
Ensure the SQL connection allows write access.
Ensure the user has appropriate permissions in both Power Apps and Power BI.
Test the app independently in Power Apps to rule out embedding issues.

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!

Quick Links

Leaderboard > Power Apps - Power Apps Experimental Features