Forum Discussion
thophan
Microsoft
Jul 16, 2020Cannot export queries
I'm trying to export the queries that I've saved in my AI Logs. Is there an easy way to export the list of queries themselves, not the results?
Thanks!
YossiY
Microsoft
Jul 29, 2020thophan hi,
You can't export the queries from the portal, but you can do it fairly easily this way:
1. Go to Saved Searches - List By Workspace REST, click 'Try it' button and fill the information for your workspace, then click 'Run'
2. You already have all the queries in JSON format, but if you want it in table format for management, copy the list of saved queries and save it as JSON file (can save to text and change file type to .json)
3. Open Excel and click 'Data' > 'Get Data' > 'From File' > 'From JSON and select your JSON file.
4. it will load in PowerQuery where you can parse it and see your queries in a table.
Yossi