Forum Discussion

Jeanxyz's avatar
Jeanxyz
Icon for Power Participant rankPower Participant
3 months ago
Solved

need help on Fabric Graph Edge

I have built a graph model. It works at the beginning. But after add an new edge (providesto) between inventory and salesevent, I try to run a query between the 2 nodes, and the query view shows no d...
  • Omkar_1712's avatar
    2 months ago

    Hello Jeanxyz,

    Since your SQL join returns data, the source relationship itself appears to be valid. The issue is likely related to how the edge is defined in the Graph model rather than the underlying data.


    I'd recommend checking the following:

    1. Verify the node keys

      • Ensure that ProductId is configured as the node key for both the Inventory and SalesEvent nodes. The Graph model uses the node keys, not just the SQL join.

    2. Rebuild the graph

      • After adding the new edge, save the model and perform a full graph reload/synchronization. In some cases, newly added edges are not materialized until the graph is rebuilt.

    3. Delete and recreate the edge

      • If the problem started immediately after adding the providesto edge, recreate it to rule out a metadata issue.

    4. Validate the edge independently

      • Create a simple query using only the providesto edge. If it still returns no data while the SQL join succeeds, it may indicate a limitation or issue with the current Graph (Preview) feature.


    If none of these steps resolve the issue, I recommend opening a Microsoft support ticket, as this may be related to the current preview implementation of Fabric Graph.

    Best regards,
    Omkar Shinde
    Microsoft Fabric Enthusiast | Power BI Consultant

    💡 If you found this response helpful, please consider giving it a Kudos.
    If this resolves your question, please mark it as the Accepted Solution to help others in the community.