Certificate support for service principal authentication.
ACS retirements require Entra ID authentication, but SharePoint authentication requires a certificate.
Fabric API for getting overages and smoothed operations
Management metric apps have delays in data freshness, so getting via the API about the latest operations and CU smoothing status provides the following benefits
- Avoid additional bill by checking before Fabric Capacity is paused.
- Creating custom alerts
Support KQL materialized view reference OneLake shortcut
Currently, materialised views cannot reference external tables.
For data curation, it is important to combine Lakehouse table dimensions (cold data) with KQL tables (hot data).
Support for this feature improves data manageability.
OpenAI(or other cognitive skill) API plugin in KQL
Kusto's http_request_post plugin doesn't support table input. We need a plugin that allows us to use an external AI model for enrichment.
Warehoues query view can export csv/excel file
To output data in the query view we need either an Excel add-in installation or Azure Data Studio. I like the ability to export data regardless of the client environment
GROUP BY ALL statement
Non-aggregate columns in select can be used for GROUP BY.
Snowflake example (https://docs.snowflake.com/en/sql-reference/constructs/group-by
>Specifies that all items in the SELECT list that do not use aggregate functions should be u...
enhance query profile
Information about the profile of a query, particularly storage scan data, is shown while the query is running.
This is common in DWH products:
https://docs.databricks.com/en/sql/user/queries/query-profile.html
https://do...
Come back Power BI Data Alert
Data Alerts in Power BI have been transformed into Data Activator. This change implies that scenarios which previously ran under the Power BI cost now necessitate an additional expense for Fabric. I'd prefer a version with limited features that includes data monitoring capabilities under a Pro...
Support for copying from sharepoint folders in data pipelines
Ensure that Binary copy is available in the Sharepoint folder (documents).The current workaround is a call to the Sharepoin API, which is not suitable for large numbers of file copies
Mirroring/Shortcut or Import from Log Analytics
Facilitate analysis on Fabric using Log Analytics. Through mirroring or shortcuts to the KQL database, we can make it possible for data to be used in near real-time and with zero copy for BI analysis via Direct Lake or with AI Skills. This feature will also s...