Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 6u6MgAPzilso5WuHL0HQbq
Power Apps - Power Apps Experimental Features
Suggested answer

data write back to the SQL database using Power Apps

Like (0) ShareShare
ReportReport
Posted on 2 Jan 2025 10:26:44 by 4

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?

  • MK-02011006-0 Profile Picture
    4 on 03 Jan 2025 at 11:09:45
    data write back to the SQL database using Power Apps
  • MK-02011006-0 Profile Picture
    4 on 03 Jan 2025 at 11:06:56
    data write back to the SQL database using Power Apps

    Hi Vasanth,

    Thank you very much for your answer.

    1. 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? 

    2. Update Power BI Settings for Power Apps Integration: I can't find the "Enable input" option anywhere. Could you please provide a screenshot?

    3. 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!


     
  • Suggested answer
    VASANTH KUMAR BALMADI Profile Picture
    266 on 03 Jan 2025 at 06:31:37
    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:

    1. Go to your Power BI report.
    2. Select the Power Apps visual you’ve embedded.
    3. 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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Power Apps Experimental Features

#1
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

#2
Julien1 Profile Picture

Julien1 7

#2
ronaldwalcott Profile Picture

ronaldwalcott 7

Overall leaderboard

Featured topics