Forum Discussion

smpa01's avatar
smpa01
Community Champion
3 years ago
Solved

Debugging 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...
Need Help
  • jeffrey_wang's avatar
    jeffrey_wang
    3 years ago

    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.

AlexisOlson's avatar
AlexisOlson
Super User
3 years ago

It seems like a bug to me since it gives the following error rather than something more descriptive but, as PhilipTreacy mentioned, the official documentation doesn't say that it's supported.

 

 

Interstingly, dax.do doesn't throw an error for the query

 

EVALUATE {TOJSON(GENERATESERIES(1, 100000,1),-1)}

 

smpa01's avatar
smpa01
Community Champion
3 years ago

I 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's avatar
    jeffrey_wang
    Power BI Team
    3 years ago

    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.