To store Power BI table data into Dataverse, you have two easy ways:
1. Using Power Automate (Best for Small Data and Automation)
Open Power BI and add a Power Automate visual from the Visualizations panel.
Click the three dots (More options) > Edit to create a new flow.
Add the "Export data" action to get table data from Power BI.
Add the "Add a new row" action for Dataverse.
Choose your Dataverse table and map the data fields from Power BI.
Save and Run the flow to send the data to Dataverse.
2. Using Power BI Dataflows (Best for Large Data & Scheduled Updates)
Open Power BI and load your data in Power Query Editor.
In Power Apps, go to Dataflows and click New Dataflow.
Choose Power BI as the data source and select your table.
Map your data fields to the correct Dataverse table.
Save the dataflow and refresh it to load data into Dataverse.
Power Automate is good for small updates, and Dataflows are better for big data.
Was this reply helpful?YesNo
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.
2,249
Share
Report
All responses (
Answers (
