Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi i need a help pulling data with a count of 100 id's from the list of 40000 id's can anyone any query. what chages i have to do in this query .
Hi @Anonymous ,
What are you trying to achieve here? Are you just trying to pull a 100-value sample set?
If so, you could do something along these lines:
First, add an [Index] column into your table starting from 1.
Then add this as a filter:
Table.SelectRows(previousStep, each Number.Mod([Index], Table.RowCount(yourTable) / 100) = 0)
Pete
Proud to be a Datanaut!
i have list of 40000 id's and i have to pull that list in my table but i have to pull that with some iteration one iteration contains [i]=100 id and next iteration [i]=i+100
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.