Forum Discussion
Power App with Power BI Bulk Update
I have a report using the desktop version of Power BI and using the Power Apps I can update records in that report, one at a time. Is there a way to do a bulk update to those records using the Power App. For example filter a number of records and update the status field to "Yes". I am using an Excel Workbook from OneDrive.
4 Replies
Hello,
Yes, I think you can bulk updates to the report.
In Power Apps, by adding a new screen and add a table or gallery to display the records you want to update.
Set up the filters as per your requirement.
Set a button that will trigger the bulk update process.
And patch it with the file on Onedrive.
Thanks,
Yes, you can do that.
You can use a gallery and pass the PowerBiIntegration.Data in the gallery. So now all the Power BI Data will be coming inside the gallery as record.
Now you have 2 options: [As you have not mentioned what and how to filter, exactly]- Create a dropdown for filter purpose which will filter the gallery data based upon the item/value selected in the dropdown. And if it serves the purpose and all the data matches inside the gallery whose value you want to update the status field to "Yes". then create the button where you can make use of forall Patch and update appropriately to bulk-update.
- Bring all the data in the gallery. No filters. Use checkmark controls and put it inside each record. Checkmark the records which are to be updated. Make use of a button control. Write a code on that button control which bulk updates the checkmarked records. (First store the checkmarked records in the collection & then make use of forall patch and update to bulk update)
Thank you.
If my answer helps you, please mark it as solution.
FYI: I have created several Power Apps(Canvas Apps) and also embedded a Power Apps in Power BI which makes me eligible to write this answer. Feel free to reach out if you have any queries on the same.