Best way to extract data from path flows

jocelynn5595058 15-12-2019

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?

 

EDITED:

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?

 

- thank you -

 

 

 

 

 

Mark Solution

Are these answers useful?
Help other community members by marking useful answers as accepted.

Accepted Solutions (0)

Answers (1)

Answers (1)

ashokkumarm 16-12-2019

Hi @jocelynn5595058 

 

Try to create "Report Builder Request (In Excel)" with following process.

 

Option 1:

 

Step 1 : Create Page Path query for Page > Level1 Pages (Give limit 1000+) (Report Builder has restriction of maximum 50000 rows)

Step 2: Create dependent Page Path query for with above 1000+ rows as reference to Level2 Pages

 

 

Option2:

 

Create Page path query for Page > Level1 pages (All Pages) > level2 pages (All Pages) then give maximum limit 50000.

 

You will get the page flow as Page > Level1 Pages > Level2 Pages

 

Regards

Ashok