Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
I hope you had a great Christmas!
I'm new working with APIs in BI. I have a json body that works well when there is one carrier.
= Text.ToBinary("{""object_type"": 7, ""carrier_id"": 20}")
But I need to add more than 30 carrier and it will be a pain to create a query for each carrier.
Does anyone know if it possible to add an array to the existing json body?
This is what I had in mind but it didn't work.
Text.ToBinary("
[
{""object_type"": 7, ""carrier_id"": 1},
{""object_type"": 7, ""carrier_id"": 2},
.............
{""object_type"": 7, ""carrier_id"": 30},
]
")
Any help would be appreciated. 🙂
Hi @Anonymous ,
Text.ToBinary can only deal with one elemental, I suggest you to try List.Transform or List.Generate which can process multiple elements one by one in a queue:
List.Transform - PowerQuery M | Microsoft Learn
List.Generate - PowerQuery M | Microsoft Learn
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.