JSON_OBJECTAGG and JSON_ARRAYAGG are new functions in Azure SQL to build JSON objects and arrays from SQL data or columns. It would be great if these functions could be added to Fabric warehouse as well to further improve support for JSON and allow for greater flexibility when working with semi structured data.
2 Comments
- fbcideas_migusrNew MemberStatus added:New
- jovanpop-msft
Microsoft Employee
Status changed:NewtoCompleted
Recent ideas
Support Encrypted Sensitivity-Labeled Excel Files in Power Query
Description Currently, Power Query Online and Power Query in Excel are unable to access encrypted Excel files. Excel files with sensitivity types other than Public or Non-Business can be encrypted a...ewarstdhyjugkhi2 minutes agoMicrosoft EmployeeNew0Views0likes0CommentsAuto-propagate Lakehouse (Direct Lake) permissions to users assigned to a Power BI App audience
Problem When a Power BI report uses a Live Connection to a Direct Lake Semantic Model, end users must have explicit ReadAll / ReadData permissions on the underlying Lakehouse (or its SQL analytics e...majofv2 hours agoNew MemberNew5Views1like0Comments