Forum Discussion

mansiluthra12's avatar
mansiluthra12
Helper I
4 years ago
Solved

Table.FromRows(Json.Document(Binary.Decompress(Binary) - how to find this source?

I have a existing dashboard in which there a table with following source . Basically all the data in that dasboard is loading from sharepoint . Where I can find this foler 
Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlHSUXJ0BBJOiUXJqTn5eYlAdlhiTmpecmaiUqxOtJIpTAVcFFkxSIUZTIVvYkpRZgqQEZSfC5Eyh0mBReAqQFIW2GxGkrfEMBXVVkMDkAInfE43NIQpwel2QyOQEmesjjc0hslhut7QBCaHbDtCqymaViRbYwE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [ID = _t, Company = _t, Origin = _t, Destiny = _t]),

 

Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    This is a manually added reference table that is packed up to save space.  You can represent it simpler by using the #table syntax if you want.

    #table({"ID","Company","Origin","Destiny"},
    {{"4","AA","Barcelona","Valencia"},
    {"5","AA","Valencia","Barcelona"},
    {"6","AA","Madrid","Roma"},
    {"7","AA","Roma","Madrid"},
    {"8","AA","Barcelona","Madrid"},
    {"9","AA","Madrid","Barcelona"},
    {"10","AB","Barcelona","Valencia"},
    {"11","AB","Valencia","Barcelona"},
    {"12","AC","Madrid","Roma"},
    {"13","AC","Roma","Madrid"},
    {"14","AC","Barcelona","Roma"},
    {"15","AC","Roma","Barcelona"}}
    )

    This is unrelated to Sharepoint.

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    This is a manually added reference table that is packed up to save space.  You can represent it simpler by using the #table syntax if you want.

    #table({"ID","Company","Origin","Destiny"},
    {{"4","AA","Barcelona","Valencia"},
    {"5","AA","Valencia","Barcelona"},
    {"6","AA","Madrid","Roma"},
    {"7","AA","Roma","Madrid"},
    {"8","AA","Barcelona","Madrid"},
    {"9","AA","Madrid","Barcelona"},
    {"10","AB","Barcelona","Valencia"},
    {"11","AB","Valencia","Barcelona"},
    {"12","AC","Madrid","Roma"},
    {"13","AC","Roma","Madrid"},
    {"14","AC","Barcelona","Roma"},
    {"15","AC","Roma","Barcelona"}}
    )

    This is unrelated to Sharepoint.

    • learnmtd's avatar
      learnmtd
      New Member
      3 years ago

      Hi, is this written manually or can it be generated through actions and applied steps...I am having a similar issue where I am trying to generate this source.

      I have a query that is written:

      = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WckpNLEpRitWJVnLJTy4NzkzPA3OCE3NSi9Pyi5JTFXwTi7JTSzLz0hWcc/JLU9ClwUyIlIKugnN+bm5pXmZJpUJAYlFJXmpRMX71QW6OCo6lJfm5iSWZ+ehW6wanFpVlAmkkiwMUQlITc5ViYwE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Team = _t])

      Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlHSUXJ0BBJOiUXJqTn5eYlAdlhiTmpecmaiUqxOtJIpTAVcFFkxSIUZTIVvYkpRZgqQEZSfC5Eyh0mBReAqQFIW2GxGkrfEMBXVVkMDkAInfE43NIQpwel2QyOQEmesjjc0hslhut7QBCaHbDtCqymaViRbYwE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [ID = _t, Company = _t, Origin = _t, Destiny = _t]),

       

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        Same process. Run it through a Base64 decoder and unzip it.

         

        [["4","AA","Barcelona","Valencia"],["5","AA","Valencia","Barcelona"],["6","AA","Madrid","Roma"],["7","AA","Roma","Madrid"],["8","AA","Barcelona","Madrid"],["9","AA","Madrid","Barcelona"],["10","AB","Barcelona","Valencia"],["11","AB","Valencia","Barcelona"],["12","AC","Madrid","Roma"],["13","AC","Roma","Madrid"],["14","AC","Barcelona","Roma"],["15","AC","Roma","Barcelona"]]

        Then parse it with the JSON parser.

         

        Again, this is only to save some space. There is no other purpose.