Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
tommycn
New Member

How to bind custom functions on ontology

Hello, I have now created an ontology according to the instructions, and I would like to develop a function on the store, such as grouping by region, groupByRegion(), In this way, when I use the data agent and ask 'Please group the stores by region', the agent can automatically call groupByRegional(). How can I implement this feature? Thank you.

tommycn_0-1773801405877.png

tommycn_1-1773802530336.png

tommycn_2-1773802761027.png

 

 

 

3 REPLIES 3
Asmita_27
Advocate II
Advocate II

Hi @tommycn,

Just add 

"Support group by in GQL"
this statement in your agent prompt. It's mentioned in official document also. 
arabalca
Impactful Individual
Impactful Individual

Hi @tommycn ,if this helped you, I’d appreciate it if you could mark it as the accepted solution and give it a like 👍
This helps others in the community find the answer more easily.
Thanks! 🙌

arabalca
Impactful Individual
Impactful Individual

Hi @tommycn ,

 

Have you used graph relationships?

On the other hand, you could add instructions to the agent, but if this comes inherited from the ontology, it will provide better results.

 

Hope this helps. If you have already found the solution, it would be great if you could share it

Helpful resources

Announcements
June Fabric Update Carousel

Fabric Monthly Update - June 2026

Check out the June 2026 Fabric update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Top Solution Authors
Top Kudoed Authors