Allow export of data formulated via an Arcade Expression in ArcGIS Dashboard

[AryamanBhattacharya_BeansAI]

We have several clients for whom we maintain data in separate hosted feature layers created specifically for each individual client. Other teams in our organization, such as Sales and Operations view this data in an ArcGIS Dashboard. 

The visualization in ArcGIS Dashboard is setup using an Arcade Expression which collates data from the individual hosted feature layers. Currently there is a requirement to export this collated information into a CSV. However, the option to enable 'Download source data' is absent when using Arcade Expression. I understand that this could be an expected behavior since data expressions technically convert a feature layer into a feature set which takes away the ability to export but it would be extremely beneficial to us and several other organizations if such feature sets could exported out as different formats.  

[HollyTorpey_LSA]

Yes please!! Similar idea here: Export table as csv created with data expression - Esri Community

[ReubenWolff]

Yes please 

[ReubenWolff]

I believe that I have found a solution.

It involves using the ArcGIS Online Assistant to edit the dashboard JSON. I have used the ArcGIS Online Assistant before with mixed results. I strongly suggest that you make a copy of your dashboard before making these edits. I have only tested it using Tables that display arcade generated features. I offer no guarantees.  Here's the process that I used:

First get the item id of the dashboard and the name of the table (Edit Dashboard: Table: General: Settings: Name).

Then open ArcGIS Online Assistant https://ago-assistant.esri.com/ and log in.

• Enter the item id of the dashboard into the Search and click enter.
• The search results should only show the one dashboard.
• Select 'I want to View an items JSON'.
• Click on the search results to open the JSON.
• Scroll down to the Data Section.
• Click the pencil icon to edit the JSON
• I use the Chrome 'Find' to search for the Table Name.
• If it finds the table I then scroll down to find:
  • "returnDistinctValues": false,
    "allowSourceDownload": false,
    "allowSummaryDownload": false
• Edit this to:
  • "returnDistinctValues": false,
    "allowSourceDownload": true,
    "allowSummaryDownload": true
• Scroll back up to the top of the Data Section and save your edits.
• Open your dashboard and the table should now have the 3 dots.

This is working for me for both privately and publically shared dashboards.

I hope it works for you.

[AryamanBhattacharya_BeansAI]

Interesting suggestion there @ReubenWolff ! I will give it a try and let you know how it goes.