Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

BSON Processing

Does anyone know of any good references for processing BSON in PowerBI? I know of these https://learn.microsoft.com/en-us/powerquery-m/binary-functions built in library functions for binary data but ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

HI Anonymous,

You can use web connector to getting data from correspond API ,then use json function to receive these data with correspond Encode and transform them to table format.

Web.Contents - PowerQuery M | Microsoft Learn

Json.FromValue - PowerQuery M | Microsoft Learn

BTW, if you are working with MongoDB with BSON data format, you can also refer to the following link if helps:

Connect from Microsoft Power BI Desktop - MongoDB 
Regards,
Xiaoxin Sheng