topic BSON Processing in Developer

BSON Processing

Anonymous — Thu, 31 Aug 2023 20:26:18 GMT

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.

Re: BSON Processing

Anonymous — Mon, 04 Sep 2023 01:15:10 GMT

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

Re: BSON Processing

Anonymous — Thu, 15 Feb 2024 20:43:33 GMT

BSON Processing is not available in Power BI at this time