Forum Discussion
TinaSchiavitti
Jun 09, 2020Copper Contributor
Excel Pivot not refreshing from MS Forms data
Excel file in OneDrive- Forms Data not refreshing in pivot table I created a new Form from Excel using MS Forms. When I open the excel file in OneDrive that holds the data, I also have a p...
SergeiBaklan
Jun 10, 2020Diamond Contributor
Another way is to connect the file to Power BI workspace (connect, not import) and schedule refresh for it. Assuming that creating PivotTable you added data to data model. It won't refresh the data on every Form update, only few times per day. But automatically.