Search for a command to run...
Principal Program Manager, Microsoft Fabric CAT helping users and organizations build scalable, insightful, secure solutions. Blogs, opinions are my own and do not represent my employer.
Last week Microsoft released an open-source text embedding model called Harrier in three sizes- 270M, 0.6B and 27B. I have been testing it in my RAG pipeline and so far it has crushed all my metrics.
For Power BI Copilot and Data agents with semantic models, you must use Prep Data for AI configuration to ground the responses in the context added in Prep for AI. In this blog, I will show you how yo
At FabCon Atlanta last week, the updated notebook Copilot for data engineering and data science was announced. It brings agentic capabilities to the Copilot and is much more intelligent and Fabric-awa
Using Fabric data agent Python SDK
Use workspace monitoring to monitor MCP server use
In Fabric, if you want to query a delta table from a lakehouse in another workspace, you create a shortcut to that table. Similarly, in Eventhouse, you can also create shortcuts to Eventhouses in other workspaces, but the option might not be immediately obvious in the GUI. If you click on New > OneLake shortcut, it creates a shortcut to a delta table, not an Eventhouse.
You have two options if you want to query a table from Eventhouse1 in Workspace A from Evenethouse2 in Workspace B.
You will need three things about the Eventhouse/table you want to shortcut:
ClusterURI : You can either get that from the UI or by using KQL : print current_cluster_endpoint() .
Database name
Table name
Create a database shortcut by selecting + Database > New shortcut database (follower). Then enter the cluster URI, select database. Optionally you can also set the caching policy for hot cache. This will add the database as a shortcut along with all its tables.
You can also query specific tables from another cross-workspace Eventhouse using
let ClusterUri = "https://<cluster_guid>.z1.kusto.fabric.microsoft.com";
let DatabaseName = "<kqldbname>";
let KQLTableName = "<table>";
let _mytable =
cluster(ClusterUri).database(DatabaseName).table(KQLTableName)
| summarize
avg_temp = avg(Temperature),
avg_humidity = avg(Humidity)
by Occupancy;
_mytable
Using the above method you can perform cross-cluster joins and unions.
Why is this important ? Well, you will see next week !