Forum Discussion

jandersoniqz's avatar
jandersoniqz
Regular Visitor
6 months ago

Unexpected High Cost on Simple Use Case

Has anyone had challenges controlling cost on IQ, specifically from Ontology? 

 

We enabled IQ based on these instructions at tenant level: Ontology (preview) required tenant settings - Microsoft Fabric | Microsoft Learn

 

The sample data we are working with has about 11 tables and ~100k records total across all tables. We spent a few hours during one day experimenting to set up an ontology on top of this schema and it cost us ~$200. Checking the Metrics app we can see this came from underlying Graph usage. 

 

Does anyone know how to better control this cost? 

3 Replies

  • Hi jandersoniqz 
    The same thing has happened to me. We are currently testing and, while I understand that optimizations will improve over time, I think it is important to acknowledge something: AI workloads like this are not designed to run efficiently on small capacities such as F2 or F4.
    In my opinion, Fabric IQ brings a lot of value and is something that you almost need to have in your roadmap. However, we also need to be aware that this value comes with a cost. This is where a key aspect comes into play: DataOps.
    We are moving into more complex scenarios (real-time, agents, graphs, etc.), and this means it is no longer just about building solutions. We need to start thinking seriously about:
    - The ROI of each use case
    How to optimize capacity consumption
    Which workloads truly justify this level of investment
    As an additional recommendation, I believe it will be key to:
    Properly separate environments (dev/test/prod) to avoid unnecessary capacity consumption
    Monitor usage from the beginning
    Prioritize use cases with real business impact
    Set capacity limits, configure alerts, and ensure workloads do not block or saturate the capacity
    Thanks for sharing your experience. If you notice any updates or improvements, it would be great if you could share them

  • Hi jandersoniqz ,

     

    Hi,
    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!