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.

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.