Excel Pivot not refreshing from MS Forms data

[TinaSchiavitti]

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 page with pivot table to analyze the data.

I can't seem to get the pivot table to auto-update as the new entries are received, although the data source page that collects the forms data is updating fine.

The only way to update pivot table is to open it in desktop version, and then change the data source properties to show the new rows of data.  Then save back to online version.

Is there another way around this?

[TinaSchiavitti]

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 page with pivot table to analyze the data.

I can't seem to get the pivot table to auto-update as the new entries are received, although the data source page that collects the forms data is updating fine.

The only way to update pivot table is to open it in desktop version, and then change the data source properties to show the new rows of data.  Then save back to online version.

Is there another way around this?

[#3]

@TinaSchiavitti 

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.