Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
HI @dylang,
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
BSON Processing is not available in Power BI at this time
BSON Processing is not available in Power BI at this time
HI @dylang,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
3 | |
2 | |
2 | |
2 |