One important thing to note is I don't have the Enterprise version of Arcgis, only AGOL.
I have an Excel file in OneDrive containing sales data for different bakeries, which is updated regularly. I'm using ArcGIS Pro desktop and have upgraded my ArcGIS Online (AGOL) subscription to the GIS Professional Standard level. My goal is to automatically update an AGOL dashboard widget, likely a pie chart, with the latest sales data whenever the Excel file is updated.
I've created a map in ArcGIS Pro with points for each bakery location, linked by a unique bakery ID that's also in the Excel file. While I can link the Excel data to ArcGIS Desktop using "relates," I encounter an error when trying to publish the map to AGOL, stating the Excel table needs to be part of the geodatabase. Upgrading to GIS Professional Standard hasn't solved the issue. This did allow me to make relationship classes, which I thought would help but basically I end up with a snapshot of the Excel when I created the relationship class that I couldn't get to update/refresh the data, or at least I couldn't figure it out, when I published the map to AGOL but might be missing something.
How can I ensure that updates to the Excel file reflect in an AGOL dashboard automatically using just the tools available to me in AGOL or Arcgis Desktop since I don't have Arcgis Enterprise? Possible?