Is there a way to bulk add or update powerapps linked within PowerBI? I know there are few videos online, but they are just generic and the powerapps is not connected in PowerBI.
Let me know your thoughts or any referal link of the tutorial for that.
Yes, it is possible to bulk add or update data in PowerApps that is linked within Power BI. To accomplish this, you can follow these general steps:
Prepare your CSV file: Make sure your CSV file contains the data you want to import or update in PowerApps. The file should have a column for each field you want to update.
Create a connection between PowerApps and Power BI: To establish a connection between PowerApps and Power BI, you can use Power Automate (previously known as Microsoft Flow). Power Automate allows you to automate workflows between different applications, including PowerApps and Power BI. You'll need to create a flow that triggers when a new item is added or updated in Power BI and performs the necessary actions in PowerApps.
Create a flow in Power Automate: In Power Automate, create a new flow and set up a trigger that corresponds to your requirements. For example, you can use the "Power BI - When a data-driven alert is triggered" trigger or the "Power BI - When a data-driven alert is updated" trigger.
Add actions to the flow: Once the trigger is set, you can add actions to the flow to perform the desired operations in PowerApps. For example, you can use the "PowerApps - Update a record" action to update existing records in PowerApps or the "PowerApps - Create a record" action to add new records.
Map the fields: When configuring the update or create actions, you'll need to map the fields from your CSV file to the corresponding fields in PowerApps. This ensures that the data is correctly updated or added.
Test and run the flow: After setting up the flow, you can test it to ensure that the data is correctly imported or updated in PowerApps. Once you're satisfied with the results, you can save and activate the flow, allowing it to run automatically based on the trigger conditions you specified.
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2