Forum Discussion
Power Participantneed 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 data available. The same error when I try to run other queries.
I did some check , and we can exclude the following scenario already:
1. graph model is not synced with source data in warehouse
2. graph query view is not refreshed
3. the relationship I built in graph is not valid (I have join the two in T-SQL using the same lookup key and it works).
4. there is more productIds or less productIds in the Inventory (i.e., dimwarehouse) table vs the salesevent table.
select i.ProductId, sum(s.RevenueUSD)
from dimwarehouse i
join factsales s on i.ProductId = s.ProductId
group by i.ProductId
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: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.
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.
Delete and recreate the edge
If the problem started immediately after adding the providesto edge, recreate it to rule out a metadata issue.
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.
3 Replies
- Omkar_1712
Solution Specialist
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: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.
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.
Delete and recreate the edge
If the problem started immediately after adding the providesto edge, recreate it to rule out a metadata issue.
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. 
v-abhinavmuCommunity Support
Hi Jeanxyz,
Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to Omkar_1712 for sharing valuable insights.
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.
- v-abhinavmu
Hi Jeanxyz,
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you