Forum Discussion
smpa01
Community Champion
Community ChampionDebugging TOJSON
Is there a reason why dynamic Max Rows in TOJSON does not work?
Table = {TOJSON(GENERATESERIES(1, 100000,1),-1)}
opposed to fully working TOCSV
Table = {TOCSV(GENERATESERIES(1, 10000...
There was a bug when MaxRows is -1 that was fixed recently. You need to wait for the next Desktop release. Unfortunately dynamic expression for the MaxRows parameter isn't supported.
smpa01Community Champion
Community ChampionI have an application where it can become extremely useful.
I really don't care about -1. I only want an expression/dynamic expression to include all rows.
BTW it does not work too.
jeffrey_wang can you shed some light if it is doable.
jeffrey_wang
Power BI Team
Power BI TeamThere was a bug when MaxRows is -1 that was fixed recently. You need to wait for the next Desktop release. Unfortunately dynamic expression for the MaxRows parameter isn't supported.