Forum Discussion
Converting Base64 value to use in pagination
Hello all, I have a working solution that I am looking to improve, The challenge I am running into is this, the api I am connecting to uses page [size] with a max of 100 and page[number] which return...
Greg_Deckler
Community Champion
Community ChampionAnonymous I actually cover this topic on The Definitive Guide to Power Query (M). You can binary encode and decode on the fly using something like this to decode for example:
let
Source =
Text.FromBinary(
Binary.Decompress(
Binary.FromText(
"Base64 encoded text",
BinaryEncoding.Base64
),
Compression.Deflate
)
)
in
Source