Export UAApp data in fixed number of rows

%3CLINGO-SUB%20id%3D%22lingo-sub-211221%22%20slang%3D%22en-US%22%3EExport%20UAApp%20data%20in%20fixed%20number%20of%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-211221%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20was%20wondering%20if%20anyone%20can%20advise%20if%20it's%20possible%20to%20extract%20UAApp%20table%20rows%20in%20fixed%20sets.%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20example%20a%20UAApp%20table%20we%20are%20working%20with%20has%20500000%20rows%20of%20data.%20Analytics%20has%20a%205000%20row%20export%20cap%20and%20PowerBI%20is%20limited%20to%20150000.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20it%20possible%20to%20create%26nbsp%3Ba%20query%20that%20allows%20us%20to%20export%20rows%20in%20groups%20i.e%26nbsp%3B1-150000%2C%20then%20rows%20150001%20-%20300000%20etc%20%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-253891%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20UAApp%20data%20in%20fixed%20number%20of%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-253891%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Will%2C%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EApologies%20I%20did%20not%2C%20in%20the%20end%20we%20had%20to%20create%20multiple%20queries%20to%20pull%20the%20data%20out%20then%20use%20PowerBI%20to%20join%20them%20into%20one%20unique%20table.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-242701%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20UAApp%20data%20in%20fixed%20number%20of%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-242701%22%20slang%3D%22en-US%22%3E%3CP%3EDid%20you%20figure%20out%20if%20this%20was%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

I was wondering if anyone can advise if it's possible to extract UAApp table rows in fixed sets.

For example a UAApp table we are working with has 500000 rows of data. Analytics has a 5000 row export cap and PowerBI is limited to 150000.

Is it possible to create a query that allows us to export rows in groups i.e 1-150000, then rows 150001 - 300000 etc ?

Thanks in advance

2 Replies
Highlighted

Did you figure out if this was possible?

Highlighted

Hi Will, 

Apologies I did not, in the end we had to create multiple queries to pull the data out then use PowerBI to join them into one unique table.