Forum Discussion

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago
Solved

Converting a table to javascript array of objects

I am trying to convert a table let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("Jc65DQAxCETRXog34PTgWiz338ZiCJ8YpH8OCX0kni50v0NaUveFlpWQrtby0mKVUZQSGrNc70/C54aWYZS9...
Need Help
  • Watsky's avatar
    Watsky
    4 years ago

    Try putting the value into a table visual then copying it from there.

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

Thanks. I am not doing CTRL+C on the PQ console.

I am doing this

 and pasting in chrome DEV tools, which comes out like this and it is not what I want.

 

Is it possible that it gets loaded to the correct js array of object format so that, I don't have to take any extra steps?

 

 

Watsky's avatar
Watsky
Icon for Solution Sage rankSolution Sage
4 years ago

Try putting the value into a table visual then copying it from there.

  • smpa01's avatar
    smpa01
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Anyone coming back to this thread in future, just so you know, Watsky 's method works but only for a small dataset. For large tables, only partial values get loaded into DAX tables as DAX has limitations for datatype `string`. The only safe way to make it to work is to take the values from PQ Console once it gets transferred to JSON.