Forum Discussion
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 am wondering if there are other resources out there. Context: We will be receiving BSON data back that we will be translating into tables for PowerBI.
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
2 Replies
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