What is the best way to extract path diagram data?
I am currently expanding items 1 by 1 (there are more than 1 mil items to expand), and exporting these to CSV. Are there any faster way, especially once I've drawn the relevant metrics/ dimensions?
To elaborate, eg., a path flow has 1,000++ items on one of the Page columns - at the bottom of the Page column, I would need to click on "1,000+ more" continuously to view full list, then export it as CSV, and change filename to .xlsx to run it in Excel. Upon which, data warehousing is not uniformed in any given spreadsheet (Excel, Power BI). But that's a story for another time.
Is there a way to export all data, even without clicking the "1,000+ more" expansion in the above scenario?