Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

guregini
‎03-20-2026 01:00 PM

Instantly Run and Preview Functions in Microsoft Fabric Eventhouse: No Code Required

If you haven’t already, check out Arun Ulag’s hero blog “FabCon and SQLCon 2026: Unifying databases and Fabric on a single, complete platform” for a complete look at all of our FabCon and SQLCon announcements across both Fabric and our database offerings. 

Before, using an Eventhouse function required you to write KQL queries by hand. You had to enter the function name in a query set, format the parameters correctly, and execute it just to see the results. If you needed to view the function body or its metadata, you had to run another command separately. That’s no longer necessary.

With the new Preview Functions capability in Microsoft Fabric Eventhouse, you can open the function definition, run the function, and instantly preview its results, with no manual KQL, no parameter guesswork, and no extra commands.

Why this matters

Eventhouse functions are highly effective, but as environments shift—databases expand, teams transition, and you may find yourself working with functions authored by others. Rather than making assumptions about a function’s purpose or having to create a query from scratch just to test it, you now have alternative options:

  • View the function definition instantly.
  • Run the function and preview results with a single click.
  • Test parameterized functions interactively.
  • Browse your function list with search and sorting.

This removes friction from everyday workflows. Whether you are exploring unfamiliar logic, validating outputs before building reports, or troubleshooting unexpected results, you get clarity in seconds instead of minutes. How to view or preview a function in DB Explorer, expand Functions and select a function. A read-only version of the function opens.

Select Preview results to instantly run the function and see the output. If the function has parameters, enter your values and preview the results based on your input.

The preview shows up to 100 records, providing a quick snapshot of the function’s output.

The_image_displays_a_database_query_interface_showing_a_query_for_retrieving_recThe_image_displays_a_database_query_interface_showing_a_query_for_retrieving_rec

Figure: Query results showing recent system logs, including timestamps, services, operations, and error codes filtered by a selected time range.

Explore all stored functions

You can view a complete list of all stored functions, including their folder, description, and optional sorting. Built-in search makes it easy to find specific functions, making navigation and discovery simple even in large databases.

The_image_displays_a_visual_representation_of_various_database_functionalities_aThe_image_displays_a_visual_representation_of_various_database_functionalities_a

Figure: Visualizing bike sharing analytics in Eventhouse with instant run and preview—enabling rapid data exploration without writing code.

Conclusion

The new Run & Preview Functions feature in Microsoft Fabric Eventhouse lets you instantly inspect function definitions and preview results without writing KQL or handling parameters manually. Quickly explore, test, and manage all your stored functions in one place, saving time and reducing friction.

Learn more in Create and edit stored functions.

0