Forum Discussion
Limited load from data souce
You could do it with an SQL statement but it is easier to use Keep Rows in the query editor. In your query, click on your 2nd step or on the Filtered Rows step, and on the Home tab click on KeepRows/Keep Top Rows. Put in 1000 in the popup and it should add a Keep Rows step. That way, query folding should still occur.
When you are done with your query building, you can just remove that step to get all the data when you need that.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
You could do it with an SQL statement but it is easier to use Keep Rows in the query editor. In your query, click on your 2nd step or on the Filtered Rows step, and on the Home tab click on KeepRows/Keep Top Rows. Put in 1000 in the popup and it should add a Keep Rows step. That way, query folding should still occur.
When you are done with your query building, you can just remove that step to get all the data when you need that.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat