Power Platform Community Forum Thread Details

I am working on a Power BI report that contains a table with multiple column. I want to dynamically add a "Feedback" column where user can select values like "Yes" or "No" and write this data back to SQL db.

To achieve this, I am using PowerApps. I have selected the Id (Primary Key) and Feedback columns in PowerApps, but the data from Power BI is not appearing in PowerApps. To resolve this, I imported the data using an Excel file.
Now, I am facing an issue while adding a dropdown for user feedback. I want the dropdown to allow users to select either "Good" or "Bad" and store this selection in the SQL database. However, I am unable to properly configure this functionality.
How can I ensure the data flows correctly from Power BI to PowerApps and allow users to update feedback dynamically with writeback to SQL DB? Any guidance would be greatly appreciated.

Categories:

Power Apps Pro Dev & ISV

@MG-11021051-0

You're on the right track by integrating Power BI with PowerApps for writeback to SQL — this is a powerful pattern! Let's walk through the steps to ensure everything works smoothly:

✅ Goal Recap

You want to:

Display a Power BI table with a "Feedback" column.
Allow users to select "Good" or "Bad" via a dropdown in PowerApps.
Write this feedback back to a SQL database.

🧩 Key Steps to Achieve This

1. Pass Data from Power BI to PowerApps

In Power BI:

Add a PowerApps visual to your report.
Pass necessary fields (e.g., Id, Name, etc.) to PowerApps using the visual’s data fields pane.

In PowerApps:

These fields will be available as a collection called PowerBIIntegration.Data.

✅ Important: You don’t need to import Excel — use PowerBIIntegration.Data directly.

2. Create the Feedback Form in PowerApps

In PowerApps:

Add a Gallery or Form to display PowerBIIntegration.Data.
Add a Dropdown control inside each row or form item:
Items = ["Good", "Bad"]
Bind the selected value to a variable or directly to a field.
3. Write Back to SQL Database

To write feedback to SQL:
Ensure you have a SQL table with columns like Id, Feedback.
Create a SQL connection in PowerApps.
Use the Patch function to update the SQL table:
Patch(

    '[dbo].[FeedbackTable]',

    LookUp('[dbo].[FeedbackTable]', Id = ThisItem.Id),

    { Feedback: Dropdown1.Selected.Value }

)

✅ Make sure:
The SQL table has a primary key.
The SQL connection has write permissions.

⚠️ Common Issues & Fixes

Issue	Fix
PowerBIIntegration.Data not showing	Ensure fields are passed into the PowerApps visual
Dropdown not saving	Use `Patch` or `UpdateIf` with correct SQL connection
SQL write fails	Check permissions and data types in SQL table